Macro adjustment to wait till my Zip file is open till it moves on to next step...

[sdoppke]

Hi everyone, I have a macro that opens a file from a url (its a zip file) Then it needs to call another macro to finish the process of copying the contents of the opened workbook to ThisWorkbook. I have all the script. What im hoping to get help with is getting the macro to wait on the call till the workbook (1 file) from the zip file is fully open.

Hope that helps. I didnt copy the code cause it is so excrutiatingly long and didn't think it would help much anyways.

Thanks a ton in advance.

sd

 

[cjcobra]

as a test, put a WAIT function in there to see if it helps.

Application.Wait Now + TimeSerial(0,0,1) ' (H,M,S)

 

[sdoppke]

as a test, put a WAIT function in there to see if it helps.

Application.Wait Now + TimeSerial(0,0,1) ' (H,M,S)

Good sugestion, I actually tried that earlier and it seems as though the opening of the book itself is on hold till the macro is finished. I had it waitning up to 60 seconds.

Any ideas on how to stop the macro till the book in the zip is opened and then resume?

sd