Solved: run batch file from access

[john3j]

I am trying to run a batch file from a macro in access. I have tried the following:

runApp
cmd.exe "C:\testbatch.bat"

This does not work. Can anyone help me figure out how to do this? Thanks.

[OBP]

You use the Shell Function, this is from the VBA Help

Shell Function Example@import url(office.css);' Specifying 1 as the second argument opens the application in ' normal size and gives it the focus.
Dim RetVal
RetVal = Shell("C:\WINDOWS\CALC.EXE", 1) ' Run Calculator.