To open a .exe file using Macro

Hi,

Scenario:
I have made a C program file to create some text files as per requirements depending on inputs from Excel sheet to the same folder as where the exe file is.
(I know we can use VB macros as well for the same but, needed C program in this case. )

I need help on how to open the .exe file using Macros. I tried using Shell command.
The .exe file opens but, i cannot see the output files in the same folder.
I open the .exe file manually and run the rest of the code like input from excel and it works! the output files are visible.

can anyone help me here? Is there any other way I can open the same file??? Or is it that when i am using shell command the output files are going elsewhere?

Thanks in Advance.

If you download a sample Excel file and a sample .exe file that outputs "Hello World" we may be able to help you. If the "Hello World' sends output to a file, make the file someplace where we have access to such as 'c:\users\owner\Downloads' preferably using an environment variable.

Excel vba syntax:

Please Login or Register  to view this content.

Lewis