slowing down a macro?

[orsm6]

is there any possible way to stop a macro until the workbook it needs to have open is opened? My macro runs a T-code in SAP that exports a report as a spreadsheet. there is some delay in how long that takes but once SAP has generated the report is automatically opens. the problem is my macro has run all of the code before it opens and so none of the data is copied.

thanks

 

[orsm6]

i worked out a different way.... force the workbook open rather than wait for SAP to open it.

 

[MARK858]

I see that you have a workaround but I'll post it anyway as I had already typed it and so maybe you could try

DoEvents

or

Application.Wait Now + TimeValue("00:00:05")

 

[orsm6]

I see that you have a workaround but I'll post it anyway as I had already typed it and so maybe you could try

DoEvents

or

Application.Wait Now + TimeValue("00:00:05")

i'll hold onto this also thanks