VBA - Waiting for some time before continuing to execute next Sub

Viewed 1798

so I have a Sub that will run two other macros, but I need it to run the first then, wait 1 minute, then run the second one

I've looked online and have gathered this:

Sub MainExecute
stdB18
Application.Wait(Now + TimeValue(0:01:00"))
runB18
End Sub

The problem is when I do this, it seems that it won't wait until after stdB18 has run, but instead, will wait 1 minute before running anything.

I've also tried putting the wait inside of runB18 at the top, but this makes the whole application wait before running also. Is there any way I can just make it so I can run stdB18, then wait 1 minute, then run runB18?

Thanks!

Edit: The reason I need to wait is because I need to wait for my QueryTable, which refreshes in stdB18, to load, before I execute runB18 where I have for loops that will pull data from the table.

3 Answers
Related