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