Run .exe from VBA code

[kar75]

Hi ALL

How to run .exe files from VBA code.

Anand.

[Bob Phillips]

[vba]

retval = Shell("C:\Windows\Calc.Exe",1)
[/vba]

[Zack Barresse]

If you do not want to use the Shell method, you can also use the FollowHyperlink method from any standard module (or UserForm for that)...

[VBA]Sub TestRunFile()
ActiveWorkbook.FollowHyperlink "C:\YourPath\YourFile.exe"
End Sub[/VBA]

HTH

[Ivan F Moala]

Zack, the problem with that method is it generates a modal warning msg about hyperlinks being harmfull. I have always prefered Shell or RunDll (to over come this) unless it is a Doc of an Application in which case I would use Shell API to exercute / open in default application.

[Zack Barresse]

True Ivan, I forgot to mention the warning. Thanks.