How to Run a Winbatch File from within Access97

Keywords: 	  access97

---

Question:

Can this be done? Run a winbatch file from a module withing Microsoft Access97?

I tried using the shell() function but it gives the error: cannot find file.

Answer:

If running a WBT, make sure you give both the full path to the Winbatch interpreter, as well as the full path to your WBT, e.g.,

"c:\Program Files\Winbatch\System\Winbatch.exe c:\My Directory\mywbt.wbt" 

This worked for me...

Sub junk()

Dim retval As Integer

retval = Shell("c:\program files\winbatch\system\winbatch.exe c:\z\junk.wbt", vbNormalFocus)

End Sub 

---

Article ID:   W14244

Filename:   Run a Winbatch File from within Access97.txt