Open Excel file from Word hyperlink

[mikeymay]

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

 

[blackbox]

this will open an excel workbook from word

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]

i figured it out. it's all in Word help

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

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]

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