neok71
08-20-2007, 02:41 AM
Hi,
I have problems using the Shell() function. I would like to run a .exe program located in a different hard disk than my excel. This program creates a .xml file from some inputs you enter in a windows shell that opens when you run the program. The problem I have is that when I double click the .exe it creates the .xml file in the folder I want (the folder where the .exe is located) but when i run the excel macro whith the Shell() function it creates the .xml file in an other folder. What can I do?
I have problems using the Shell() function. I would like to run a .exe program located in a different hard disk than my excel. This program creates a .xml file from some inputs you enter in a windows shell that opens when you run the program. The problem I have is that when I double click the .exe it creates the .xml file in the folder I want (the folder where the .exe is located) but when i run the excel macro whith the Shell() function it creates the .xml file in an other folder. What can I do?