Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Shell command writes file to wrong directory
I'm calling a command line exe from within Excel 2007 using VBA. The problem
I'm having is the exe outputs a file, e.g. foobar.txt, but it always puts it in the last directory I opened an Excel file from rather than the directory where the exe is being called. For example, say I open a spreadsheet in "c:\excel\worksheet.xls" and in VBA I call an exe in "c:\test\foobar.exe". The file that foobar.exe generates gets copied into "c:\excel" instead of "c:\test" Anyone know what's going on and how to prevent it? thanks, Dustin |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Shell command writes file to wrong directory
You might try using ChDrive and ChDir before Shell'ing to the exe. Either
that or use a BAT file that calls the EXE and in the BAT file use CD to change the current directory. ChDrive "C:\Test" ChDir "C:\Test" Shell "C:\Test\foobar.exe" -- Cordially, Chip Pearson Microsoft MVP - Excel, 10 Years Pearson Software Consulting www.cpearson.com (email on the web site) "Dustin" wrote in message ... I'm calling a command line exe from within Excel 2007 using VBA. The problem I'm having is the exe outputs a file, e.g. foobar.txt, but it always puts it in the last directory I opened an Excel file from rather than the directory where the exe is being called. For example, say I open a spreadsheet in "c:\excel\worksheet.xls" and in VBA I call an exe in "c:\test\foobar.exe". The file that foobar.exe generates gets copied into "c:\excel" instead of "c:\test" Anyone know what's going on and how to prevent it? thanks, Dustin |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Shell command writes file to wrong directory
I think that did it, thanks!
"Chip Pearson" wrote: You might try using ChDrive and ChDir before Shell'ing to the exe. Either that or use a BAT file that calls the EXE and in the BAT file use CD to change the current directory. ChDrive "C:\Test" ChDir "C:\Test" Shell "C:\Test\foobar.exe" -- Cordially, Chip Pearson Microsoft MVP - Excel, 10 Years Pearson Software Consulting www.cpearson.com (email on the web site) "Dustin" wrote in message ... I'm calling a command line exe from within Excel 2007 using VBA. The problem I'm having is the exe outputs a file, e.g. foobar.txt, but it always puts it in the last directory I opened an Excel file from rather than the directory where the exe is being called. For example, say I open a spreadsheet in "c:\excel\worksheet.xls" and in VBA I call an exe in "c:\test\foobar.exe". The file that foobar.exe generates gets copied into "c:\excel" instead of "c:\test" Anyone know what's going on and how to prevent it? thanks, Dustin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
send parameters to a batch file with the shell command | Excel Programming | |||
getting vba shell command to execute batch and save output to a file | Excel Programming | |||
Shell command and exe file conundrum | Excel Programming | |||
Shell Command - Net Time (Cannot create text file) | Excel Programming | |||
Copying a file with VBA (or with a SHELL command) | Excel Programming |