Open Excel file from Word hyperlink

mikeymay

Well-known Member
Joined
Jan 17, 2006
Messages
1,562
Office Version
  1. 365
Platform
  1. Windows
I know this is essentially an Excel question, but thought it would qualifyas Excel is 'part' of the question....

I am writing some procedure notes in Word and want to include a hyperlink to the required Excel files so the user can click on the hyperlink and the file will open in Excel.

I have been trying to do this as per this link http://www.shaunakelly.com/word/ExcelHyperlinks/index.html but just cannot get it to work.

Rather then my location showing a drive name and then colon, e.g. 'S:' when I copy the excel file location details using 'File', 'Properties' it shows '\\nat-fap-xxx-s01' so I am not sure how to start the file location details.


Thanks
 

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

blackbox

Board Regular
Joined
Apr 2, 2006
Messages
122
this will open an excel workbook from word
Code:
Sub CreateNewExcelWB()
' *****add a reference to the Excel-library****

Dim xlApp As Excel.Application
Dim xlWB As Excel.Workbook
Dim i As Integer
    Set xlApp = CreateObject("Excel.Application")
    xlApp.Visible = True
    
    Set xlWB = xlApp.Workbooks.Open("C:\Documents and Settings\j.doe\Desktop\My Spread Sheet.xls")
      
   
    Set xlWB = Nothing
    Set xlApp = Nothing
End Sub

never really used hyperlinks before, so, I'm not exactly sure how to add one.
 

blackbox

Board Regular
Joined
Apr 2, 2006
Messages
122
i figured it out. it's all in Word help

Code:
Select the text or picture you want to display as the hyperlink, and then click Insert Hyperlink  on the Standard toolbar.

Code:
Change the way hyperlinks are followed
By default, users follow — or open — hyperlinks by pressing CTRL while clicking the hyperlink. If you prefer, you can have hyperlinks open by just clicking them.

On the Tools menu, click Options, and then click the Edit tab. 
Clear the Use CTRL+Click to follow hyperlink check box.
 

Armster

Board Regular
Joined
Jul 26, 2007
Messages
63
hey

is it just the direct link to the excel document your after to open or for it to open to a direct location within that excel workbook ?

if its just a link to open excel this can be done like creating any hyper link. in your word document type the link text eg. excelSpreadsheet --> select this text ---> right click ---> click hyperlink ---> browse for your excel file or type the direct path in click ok
 

Forum statistics

Threads
1,181,730
Messages
5,931,718
Members
436,800
Latest member
abowalid98

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top