Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
executing batch files using VBA
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:? -- srkumar ------------------------------------------------------------------------ srkumar's Profile: http://www.excelforum.com/member.php...o&userid=20037 View this thread: http://www.excelforum.com/showthread...hreadid=534991 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
executing batch files using VBA
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") -- HTH... Jim Thomlinson "srkumar" wrote: 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:? -- srkumar ------------------------------------------------------------------------ srkumar's Profile: http://www.excelforum.com/member.php...o&userid=20037 View this thread: http://www.excelforum.com/showthread...hreadid=534991 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I batch convert 97-2003 .xls files to 2007 .xlsx files | Excel Discussion (Misc queries) | |||
Batch Files | Excel Programming | |||
Batch conversion of XP files to 97 files | Excel Discussion (Misc queries) | |||
Batch Files | Excel Programming | |||
Batch files and VBA | Excel Programming |