Does VBA Complete Shell Before Proceding

[sambo]

Will VBA continue to loop through code as the Shell runs, or does it see that the Shell is completed and then continue to run.

I call the following Shell (it copies the active .mdb into a temp file)

Call Shell("""" & batPath & """ """ & projPath & """ """ & copyPath & """", 3)

And then I take that temp file and compact it and store it at location finalDB.

DBEngine.CompactDatabase copyPath , finalDB

If the Shell is not completed by the time the code runs down to the compact, will I be in trouble? Or does it queue up until the Shell is completed?

 

[pono1]

Pretty good example

Regards,
Tim

 

[sambo]

Cool!! That looks good.