My question involves two workbooks: In workbook1 I have created a code that opens, renames and resaves workbook2. However, When workbook 2 opens it will automatically begin to run a code that can take any amount of time depending upon how long it takes to refresh certain information. My problem is that what command can I put in workbook1 that won't allow it to resave or close workbook2 untill the code has finished running. Thanks so much for you help.
Last edited by VBA Noob; 11-09-2007 at 12:23 PM.
I don't want my code to go to the next line of code until that command has been completely carried out (such as reshing information, or opending a workbook). THanks
Last edited by VBA Noob; 11-09-2007 at 12:42 PM.
Hello tchristie33,
When you open Workbook 2 from a macro in Workbook 1, control won't return to Workbook 1 until Workbook 2 has finished running. Unless you are open Workbook 2 as a hidden process, I don't see where the problem is. It would be help to see the code you are using.
Sincerely,
Leith Ross
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks