Run external program with VBA

Question

I am trying to write Excel VBA code to open an external windows program and then open a file within that external program. I've figured out how to open the program using the "Shell" command but I don't know how to use any of the programs functions once its opened. This is what I have so far. Thanks!

Program = "C:\Program Files\EP-Quick\EP-Quick.exe"
TaskID = Shell(Program, 1)

Gary's Student · Accepted Answer · 2013-09-05 18:45:11Z

2

First review SendKeys in VBA help and:

http://msdn.microsoft.com/en-us/library/gg278655(v=office.14).aspx

Then, using Google, try to find examples specific to your application

edited Sep 5, 2013 at 18:45

answered Sep 5, 2013 at 15:35

Gary's Student

96.9k10 gold badges66 silver badges104 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Run external program with VBA

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related