How to start a program with a macro

[~Zodiac~]

what code must i use to start a program with excel? (something outside the office programs)

pls help me out

Thanks in Advance

 

[Bruno_x]

Shell(pathname[,windowstyle])

 

[cherria]

The function you need is called Shell but I can find no reference to it in the VBA help.

There are 2 versions I think, Shell and Shellandwait

try searching for Excel VBA Shell in google

 

[~Zodiac~]

Thanks for the Help!

 

[~Zodiac~]

is it possible to let a excel macro to activate buttons in a program opened with the shell code?

if so, what code is used for that?

 

[Harvey]

The function you need is called Shell but I can find no reference to it in the VBA help.

There are 2 versions I think, Shell and Shellandwait

try searching for Excel VBA Shell in google

LOL, shellandwait is a usermade version it has something to do with apicalls and stuff. What it does is execute a file and wait until it is closed (useful for using winzip etc)

 

[Harvey]

Also, when you use the shell command, you can retrieve the program ID ( myProgram = shell(...) )
you can use it to activate it with AppActivate (myProgram)
Take a look at the SendKeys command for controlling other programs through VBA.

(P.S. Als je AppActivate wilt gebruiken, moet je oppassen met releaseversieverschillen. Ik heb t ook gebruikt en op sommige versies crasht ie zonder reden op AppActivate.)

 

[~Zodiac~]

Thanks for your reply Harvey

@Harvey ps heb je mijn pm over die topic al gelezen? (de topic van die zimbabwaan die over opslaan ging)

i need the macro to 'click' on a button that is 1 milimeter left of the words "equipment recipe usage", then it has to 'click' on a line with the text "to run"