shell running a bat file

[rollerjk]

I'm trying to run a bat file using the shell function and it's not working. It opens up the dos prompt then goes away. This is the code:

Shell "c:\smdr\swbdl.bat", vbNormalFocus

Is there something wrong with this or is there another approach I should take? The bat file itself works correctly.

Thank you

 

[nickjar2]

i would normally do it this way (although i don't think there is a difference)

dim i

i=shell("c:\smdr\swbdl.bat",1)

Nick

 

[rollerjk]

Thanks Nick. I tried that but didn't get the result I was looking for. I think that would just capture the programs id if the program ran sucessfully.

 

[Manny64]

This works for me:

Dim stAppName As String
stAppName = "c:\TestShell.bat"
Call Shell(stAppName,1)

Manny64

 

[Manny64]

Note: This is Access97 on WinNT

 

[Francescina]

As far as I remember you need to indicate /command.com if you want to execute BAT files with SHELL.

 

[rollerjk]

Thanks for the repsonses. The problem wasn't the vba it was in the bat file. When I ran it from vba before I fixed the problem with the bat file it ran so fast that I didn't see that the dos prompt was starting at a different directory than when I pulled up the prompt myself. All I had to do was add a change directory line at the beginning of my bat file.