How do you call a exe and interact with the output interactively

C

Chris Peel

I need to call a 3rd party application (Dos command e.g. exe) that has
output etc.

I need to call the exe and then read replies and send commands.

I'd like to do this all from VBA(Excel) and then take the output into a
excel sheet.

Is this possible ? My only other option is to create bat files from the
VBA and run those via Shell and look for outputs.

Thanks
 
K

Ken Slovak - [MVP - Outlook]

I believe you would have to run via Shell, but this group has nothing to do
with shell execution or Excel, it's for Outlook, which you post doesn't
relate to at all.
 
J

Jacob Skaria

Dear Chris

I hope you are you planning to do this in Excel.

You may use Shell and wait to finish the process...
You can reference Outlook object from Excel
Read the outputs and send replies... You can post back or post a comment in
Excel group for any help. Thanks

If this post helps click Yes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a Search using a combo box and then creating a report. 4
How to call exe file in excel? 5
How to call a exe file with output txt file function in the excel? 0
Running an executable with dependencies from a network folder 4
How to call a java application from an Excel Macro in Macoffice 0
Executing a .BAT file using excel macro 1
Shell command writes file to wrong directory 2
From EXE to DLL 0

Top