call a batch file from an Access module 1

[SlakeB]

How can I do this? I know how to call a .vbs file:

Call Shell("wscript.exe " & "myVBS.vbs", vbMaximizedFocus)



How can I call a .bat file instead?

 

[PHV]

Call Shell(Environ("COMSPEC") & " /C myBAT.bat", vbMaximizedFocus)


Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[earthandfire]

Shell should recognise known file types so:

Shell myBAT.bat

or

Shell myBAT.bat, vbMaximizedFocus

would be sufficient


Out of interest PHV, why would you want to use /C and vbMaximizedFocus - in fact, why use vbMaximizedFocus at all when running a Batch File?

Hope this helps.