WinBatch Tech Support Home

Database Search

If you can't find the information using the categories below, post a question over in our WinBatch Tech Support Forum.

TechHome

Launching WinBatch and Other Apps
plus

Can't find the information you are looking for here? Then leave a message over on our WinBatch Tech Support Forum.

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
File Created: 1999:10:26:11:22:48
Last Updated: 1999:10:26:11:22:48