execute .exe file and type a text string on it

[Marco]

Hi all,

I have a software ending with .exe that i would like to open, type the
word 'select' on it, press 'enter' and make it run.

I used the following code but vba doesn't recognize 'wd' as an
application but as a number.

Dim wd As Application

wd = Shell("Y:\--\Sel.exe", 1)

Application.SendKeys "select"

Do you have any clues about?

Thanks,
Marco

 

[Stefan Hoffmann]

hi Marco,

Dim wd As Application
wd = Shell("Y:\--\Sel.exe", 1)

Shell returns a handle to the process, not an object.

Do you have any clues about?

http://www.tek-tips.com/faqs.cfm?fid=5037

Just start your executable, wait some time, and use SendKeys. You don't
need the return value of Shell:


Shell("yourExec", 1)
Application.Wait Now() + TimeValue("00:00:01")
SendKeys "SELECT"


mfG
--> stefan <--