|
The sheet path file name ?
Hi all , How can i edit in a cell a formula to retrieve the whole path of the sheet and not only the file ! Thank you veru much. -- gaftalik ------------------------------------------------------------------------ gaftalik's Profile: http://www.excelforum.com/member.php...fo&userid=6450 View this thread: http://www.excelforum.com/showthread...hreadid=484534 |
The sheet path file name ?
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 HIS "gaftalik" wrote in message ... Hi all , How can i edit in a cell a formula to retrieve the whole path of the sheet and not only the file ! Thank you veru much. -- gaftalik ------------------------------------------------------------------------ gaftalik's Profile: http://www.excelforum.com/member.php...fo&userid=6450 View this thread: http://www.excelforum.com/showthread...hreadid=484534 |
The sheet path file name ?
http://www.officearticles.com/excel/...ft_ex cel.htm
http://www.officearticles.com/excel/...ft_e xcel.htm ************ Anne Troy VBA Project Manager www.OfficeArticles.com "gaftalik" wrote in message ... Hi all , How can i edit in a cell a formula to retrieve the whole path of the sheet and not only the file ! Thank you veru much. -- gaftalik ------------------------------------------------------------------------ gaftalik's Profile: http://www.excelforum.com/member.php...fo&userid=6450 View this thread: http://www.excelforum.com/showthread...hreadid=484534 |
The sheet path file name ?
See http://www.xldynamic.com/source/xld.xlFAQ0002.html
-- HTH RP (remove nothere from the email address if mailing direct) "gaftalik" wrote in message ... Hi all , How can i edit in a cell a formula to retrieve the whole path of the sheet and not only the file ! Thank you veru much. -- gaftalik ------------------------------------------------------------------------ gaftalik's Profile: http://www.excelforum.com/member.php...fo&userid=6450 View this thread: http://www.excelforum.com/showthread...hreadid=484534 |
The sheet path file name ?
That retrieved the file path but what about if i need to open directly the needed sheet, given more than a sheet in a file. In short i need the sheet path . -- gaftalik ------------------------------------------------------------------------ gaftalik's Profile: http://www.excelforum.com/member.php...fo&userid=6450 View this thread: http://www.excelforum.com/showthread...hreadid=484534 |
The sheet path file name ?
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 on the Standard toolbar, slect the file you want to link (one click), then click the Bookmark button, then select the sheet you want from that file. "gaftalik" wrote: That retrieved the file path but what about if i need to open directly the needed sheet, given more than a sheet in a file. In short i need the sheet path . -- gaftalik ------------------------------------------------------------------------ gaftalik's Profile: http://www.excelforum.com/member.php...fo&userid=6450 View this thread: http://www.excelforum.com/showthread...hreadid=484534 |
The sheet path file name ?
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 ? -- gaftalik ------------------------------------------------------------------------ gaftalik's Profile: http://www.excelforum.com/member.php...fo&userid=6450 View this thread: http://www.excelforum.com/showthread...hreadid=484534 |
The sheet path file name ?
Yes you can.
Use the menu InsertHyperlink... 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. "gaftalik" wrote: 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 ? -- gaftalik ------------------------------------------------------------------------ gaftalik's Profile: http://www.excelforum.com/member.php...fo&userid=6450 View this thread: http://www.excelforum.com/showthread...hreadid=484534 |
| All times are GMT +1. The time now is 08:07 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com