Fixed, part of it was I was starting the macro after setting all the variables because I did not want to run the whole script. Therefore they were empty. After I moved the let command to just before where I started it worked with the %OAC%. I removed them from that part and started the script from t...

I have a macro that creates 5 csv file reports each day. I want to open those in Excel and move them all to one sheet. Can that be done with Macro Scheduler or do I need to do this in Excel VBA. Any code hints in either would be appreciated. The names of the files change each day.

Thanks

I am creating a file name with some text and then the date: Day>the_day Month>the_month Year>the_year Let>op_account=op account %the_day%%the_month%%the_year% let>OAC=C:\Users\GPetersen\Documents\2018\Bank Reports\%op_account% Message box looks correct: C:\Users\GPetersen\Documents\2018\Bank Reports...

I fixed the syntax, but it did not seem to make a difference. After working with TRACE more it seems like the excel subroutine is not working after the first 2 times. Also, if I start at the begining of report #3, then #3 works fine, but stops at #4. Any ideas as to why? Is there something I need to...

I am using Macro Scheduler to automate 4 reports generated by Quickbooks on a terminal server. Once the reports reports are displayed on the screen I save them to an Excel file. The saving code is in a subroutine so it is the same for all 4 reports. The problem is it doesn't work for the 3rd and 4th...

Adding those lines there were no messages. Here is the log where it hangs: WaitScreenImage>C:\Users\GPetersen\Documents\Macro Scheduler 14\Month End Reports HTE\image_8.bmp,0.7,CCOEFF 6/19/2013 14:04:48:078 - 156: //SetFocus>192.168.196.40 - Remote Desktop Connection 6/19/2013 14:04:49:092 - 157: wa...

I have a script that runs 4 reports in a RDP window using QuickBooks and as such uses image recognition. The script seems to hang on reports 3 and 4 at the file name dialog box. The script uses subroutines and those work fine for the reports 1 and 2. When it gets to 3 it seems the cursor moves over ...

I think using that is above my pay grade (knowledge). I looked at it and I am not sure how to use it.

If anyone has got some example code to print to PDF I would appreciate looking at it.

thanks everyone for looking at this

This is where it is getting stuck. WaitWindowOpen>Save PDF File As SendText>FN wait>0.1 Press Enter the text always ends up in the search box at the top of the window even if I try using image recognition and mouse commands to highlight the file name box. It almost acts like the focus is being chang...

I am looking to print a web page to a pdf document. Everything works until I get to putting the file name in the dialog box. Tried several methods. This is the latest. //print screen Day>dd Month>mm Year>yyyy lettrim(%dd%),dd VBEval>trim(%mm%),mm Let>today=%mm%-%dd%-%yyyy% let>FN=C:\Users\GPetersen\...

I have 3 files written out to the desktop on the REMOTE desktop. I can copy them using image recognition etc. I am having trouble getting them to the desktop of my PC or even better to a folder somewhere. this works fine, but everything I try doesn't work. OR is there another way I should be doing t...

worked great - Thanks

I can have 2 companies open in QuickBooks Enterprise. We use a terminal server because many of us work remotely. I am using image recognition to find desktop shortcuts to start each company file. The macro works fine when stepping thru it, but when using normal speed I can't seem to get the first QB...