Hyper Linking

[thenine]

Hello,

I need some help with hyperlinking. I know how to hyperlink from a
cell, to a word document, to an excel document, and even to other cells
or worksheets within the same document.

My question is how do you hyperlink from a cell to a specific worksheet
inside of a seperte excel file?


basically i want to click on a link in one excel file and have that
link pull up a specific worksheet inside of difrent excel file.

Thanks for the help

 

[Dennis]

Hi Thenine, There is probably a way to do it with HyperLink but while you wait
for an answer here is how I do it with VBA and assigng the macro to a Forms
Button.....

Sub OpenMySheet
ChDir "C:\Temp"
Workbooks.Open Filename:="C:\Temp\My.xls" 'path to workbook
Sheets("Sheet3").Select 'if the sheet is named replace Sheet3 with
'name of sheet

End Sub

Dennis
==============