The sheet path file name ?

G

gaftalik

Hi all ,

How can i edit in a cell a formula to retrieve the whole path of th
sheet and not only the file !

Thank you veru much
 
N

Nick Hodge

If you can use a UDF in your workbook then you could use one like so

Function FullPath() As String
Application.Volatile True
FullPath = ThisWorkbook.FullName
End Function

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
[email protected]
 
G

gaftalik

That retrieved the file path but what about if i need to open directl
the needed sheet, given more than a sheet in a file. In short i nee
the sheet path
 
R

Ralph Orth

Did you get it yet? If I understand your question, you want to link another
worksheet from another file to a cell on the current page. If that is the
case, when you are in the cell you want to link, click the hyperlink button
 
G

gaftalik

What i meant is that i succeeded to add the link to that file but i need
also the file when it opens to open a specified sheet not any sheet , so
could the sheet name be included in the link or only the general file
name ?
 
R

Ralph Orth

Yes you can.

Use the menu Insert>Hyperlink... Select the file you want to link (with only
a single click), then click the Bookmark button (toward the top on the right
side of the Insert Hyperlink dialogue box), then select the sheet or name you
want to open within the file. This is in 2003, and I think others are
similar, but not certain.
 
Top