Getting output of a called external executale

[Thorsten Walenzyk]

Hi all,

I want to call an external executable (.exe in my case) from an Excel-VBA
program.
I found the Shell function, but with this function it is only possible to
get an integer return value back.

Is there is any possibility to use pipes to get the output of the external
program to VBA?

Thanks Thorsten

 

[Helmut Weber]

Hi,
if the prog produces character output,
you may direct the output to a file, maybe.
Like
shell "c:\prg\myprog.exe > c:\test.txt"

 

[AA2e72E]

Try:

Shell "Your.EXE > C:\MYFILE.TXT"

Then Open C:\MYFILE.TXT for Inpuit as #1
and read the contents of the file sequentially:

Line Input #1,A$

Use A$ in your VBA Code as required.

 

[Dave Peterson]

Maybe you could send the output from your .exe program into a text file and then
read that text file in code.