can i record a macro from excel to invvoke another windows application

[anil]

Hi all,

Is it possible to write a macro from ecxel which can invoke another
windows application. if so please let me know......

Thanks and Regards
Anil.Hungund

 

[Guest]

Yes:

1. Shell command
2. Hyperlink
3. Object creation
4. etc.

 

[Pete_UK]

Hi all,

Is it possible to write a macro from ecxel which can invoke another
windows application. if so please let me know......

Thanks and Regards
Anil.Hungund

This is taken from VBA Help for the Shell function:

Dim RetVal
RetVal = Shell("C:\WINDOWS\CALC.EXE", 1) ' Run Calculator

Put the full path to the .exe file within the quotes.

Hope this helps.

Pete