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