VBA code to open non excel programs

Solved/Closed
PM - Aug 19, 2009 at 02:39 AM
 Billybob - Jan 7, 2019 at 04:37 AM
Hello,

I need vba code to open other documents besides excel doc's

e.g open a word file, access file etc..

Can anyone help??

thanks

PM

6 replies

Iv found how it works now, thanks for your help anyway!! See below code!

ActiveWorkbook.FollowHyperlink Address:="(Enter location in here, along with file name)", NewWindow:=True
24
you can make a VBA macro stating:

Sub My_macro()

Shell ("C:\MyProgramFolder\MyProgram.exe")

End Sub


- This will open the program MyProgram.exe :)
0
it worked for me..Thank u
0
Worked a treat
0