executing batch files using VBA

[srkumar]

Hi,

I would like to accomplish the following and appreciate any advice. I
would like to create a loop using VBA that repeatedly executes a batch
file for different parameters. i tried the shell command: shell
("cmd.exe D:\abc\test.bat") but keep getting the msg.:
"cmd.exe was started with 'D:\abc' as the current directory path. UNC
paths are not supported. Defaulting to windows directory" and each time
the system returns to C:\WINNT>.

is there a way around this that allows me to execute batch files that
are located in drives other than C:?

 

[Don Guillett]

have a look in vba help for
chdir

 

[Jim Thomlinson]

A batch file is an executable file. Why do you have cmd.exe preceding the
batch file. Shouldn't it be just...

shell ("D:\abc\test.bat")