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

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.


"Thorsten Walenzyk" wrote:

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

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

Thorsten Walenzyk wrote:

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

--

Dave Peterson