Wait until Sub1 is finished

[goldyr]

I have one sub (Refresh-data) in excel that gets data via MS-query and the second sub (Format_Column) formats the column. How can I make sure that the first sub has finished before the second starts?

/Liz

 

[SkipVought]

Hi,

Sub Main()
  Sub1
  Sub2
End Sub

Skip,

http://www.TheOfficeExperts.com

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[PHV]

And be sure that the BackgroundQuery property of your QueryTable is set to False.

Hope This Help
PH.

 

[xlbo]

PHV's advice will work. Skip - even if you have the 2 subs run from a amin sub, the code can still be executing whilst the SQL is running so it could still mess up. Setting background query to false ensures that the code does not continue until after the query has been processed

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244