I have a VBA code that I run on a spreadsheet at the end of which, I'd like it to activate the already-open QuickBooks program. I'm trying to shave off as much time as possible in my tasks.
How can I do this?
UNNECESSARY EXPLANATION:
While the code is running, I activate QB and create a new invoice and start typing info but at the end of the routine it switches BACK to Excel to maximize the spreadsheet (So I can see all of it). Consequently, sometimes I'm typing when it switches back and I end up typing some of the data in the Excel worksheet mid-stream. I know the solution I'm looking for won't fix this problem completely because I still have to wait for it to switch to QB to continue typing, but I still wanna do it!
How can I do this?
UNNECESSARY EXPLANATION:
While the code is running, I activate QB and create a new invoice and start typing info but at the end of the routine it switches BACK to Excel to maximize the spreadsheet (So I can see all of it). Consequently, sometimes I'm typing when it switches back and I end up typing some of the data in the Excel worksheet mid-stream. I know the solution I'm looking for won't fix this problem completely because I still have to wait for it to switch to QB to continue typing, but I still wanna do it!