Opening other Applications From Excel

[MyFlight]

I am Trying to Open an application called Lex.exe in Excel using VBA. I was sucessfull in opening the file using the following command:

rsp = Shell("C:\Temp Data Files\Raw Data\9005lex.exe&quot

however in order to the application (lex.exe) to execute after opening I have to type a 'Y', this I cannot get to work.

Any assistance will be greatly appreciated.

 

[RobBroekhuis]

Try putting (after the shell command)

sendkeys "Y"

You may have to play with timing to get it just right.

Rob

 

[MyFlight]

I tried using the Snedkey "Y"
and it never seems to send the Key.
I even had it send the key 4 difernet times in the same script???

 

[RobBroekhuis]

Does your .exe become the active window after the shell command? How long does it take to load up? You may need to put in a pause. For example, if it takes two seconds to load up, try:

shell...
application.Wait now()+2/24/3600
sendkeys "Y"

Rob

 

[RobBroekhuis]

Does your .exe become the active window after the shell command? Rob

 

[MyFlight]

Rob,

Yes the 9005lex.exe becomes the Active window after the shell command.

 

[RobBroekhuis]

I guess it must not be a well-behaved executable. The approach above, using sendkeys, normally works. For example, I used it quite successfully for the calculator program in accessories (calc.exe).
Rob

 

[andrew299]

If your still having problems one solution may be to use the program key text

http://www.mjmsoft.com/ktreg.htm

it is a trial version and it says its for 30 days but it keeps going. It is basically like a macro for the whole of windows so it if you open it in your excel macro and run it then close it again it should deal with your y problem.
Giv it a try
Andrew299