VBA code to open non excel programs Solved/Closed

Question

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

PM · Accepted Answer

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

kaiyasit · Answer

Use hyperlinks

PM · Answer

Hi,

i want to be able to use a command button to open the files not a hyperlink.

Do you know how to do this??

kaiyasit · Answer

Do you have example for me?
I will try as you want.

PM · Answer

I dont have an exact exmple, but im assuming it would be on the lines of the below code to open an excel file. But is there a way of opening a word file or access file??

Workbooks.Open Filename:= _
        "N:\Home\Excel1.xls"

Or maybe you know of a way to assign a hyperlink to a command button, that would be a easier option.

PM · Answer

Hi 

Once the file is open, do you know how I can get the external file/doc to print using vba code??

thanks

PM

VBA code to open non excel programs

6 responses

Similar discussions

Subscribe To Our Newsletter!