running a program from Excel VBA

[Chrissirhc]

Hi,

I've done a quick search but couldn't find anything on this. How do I launch a program from within an Excel Macro?

e.g. If I wanted to run c:\program files\my program\myexecutable.exe, how would I do this from VBA in Excel? I guess I would need "Microsoft scripting runtime" installed?

Cheers,

Chris

 

[PHV]

You may simply consider the Shell VBA function.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Chrissirhc]

I just found that and was about to reply... Thanks.