calling multiple shell command in CMD via VBA in access

[Nishikawa]

Hi,

Is it possible to call multiple instructions (one after another) into CMD via VBA in access without using a BAT file.

The reason is because every instruction needs certain values from access itself.

 

[gemma-the-husky]

yes

use shell command

the only problem may be waiting for each shell to complete before preceeding to the next step, (if steps are dependent on previous steps). Access will just proceed to run the next line of vba unless you make it wait

I forget it now, but thats some sort of windows call, i think

 

[WayneRyan]

ShellAndWait:

http://www.access-programmers.co.uk/forums/showthread.php?t=74481&highlight=shell+wayne

Wayne

 

[Nishikawa]

Thanks for your help. I will be taking a look at the thread. As I was waiting for help. I did it in another way. I made VBA to create a txt file, convert it to .bat and use a shell command to run it. In that case, I will not have to shell and wait.

 

[gemma-the-husky]

if you need to rely on the RESULTS of running the .bat file, then you still need to wait, surely