Hi everyone.

I have a very simple request, but I have been unable to find the
answer.

I want to have the filename of the excel file shown in a cell in that
file. Similar to the &[File] command in the header or footer, but
shown in a cell that can then be reffered to in other worksheets.

I hope someone knows the answer.

Cheers

Ian


--
milnei
------------------------------------------------------------------------
milnei's Profile: http://www.excelforum.com/member.php...o&userid=28235
View this thread: http://www.excelforum.com/showthread...hreadid=477853

One way

=MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,FIND("]",CELL("file
name",A1))-FIND("[",CELL("filename",A1))-1)

the reference to A1 can be any replaced by any cell, even the cell that
holds the formula

--

Regards,

Peo Sjoblom

"milnei" wrote in
message ...

Hi everyone.

I have a very simple request, but I have been unable to find the
answer.

I want to have the filename of the excel file shown in a cell in that
file. Similar to the &[File] command in the header or footer, but
shown in a cell that can then be reffered to in other worksheets.

I hope someone knows the answer.

Cheers

Ian


--
milnei
------------------------------------------------------------------------
milnei's Profile:
http://www.excelforum.com/member.php...o&userid=28235
View this thread: http://www.excelforum.com/showthread...hreadid=477853

Fantastic, Christmas has come early...... :)


--
milnei
------------------------------------------------------------------------
milnei's Profile: http://www.excelforum.com/member.php...o&userid=28235
View this thread: http://www.excelforum.com/showthread...hreadid=477853

Hi

Could you tell me how to get the 'tab' name of the excel file shown in a
cell in that
file. Similar to the &[Tab] command in the header or footer.

Thanks you your help.


"Peo Sjoblom" wrote:

One way

=MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,FIND("]",CELL("file
name",A1))-FIND("[",CELL("filename",A1))-1)

the reference to A1 can be any replaced by any cell, even the cell that
holds the formula

--

Regards,

Peo Sjoblom

"milnei" wrote in
message ...

Hi everyone.

I have a very simple request, but I have been unable to find the
answer.

I want to have the filename of the excel file shown in a cell in that
file. Similar to the &[File] command in the header or footer, but
shown in a cell that can then be reffered to in other worksheets.

I hope someone knows the answer.

Cheers

Ian


--
milnei
------------------------------------------------------------------------
milnei's Profile:
http://www.excelforum.com/member.php...o&userid=28235
View this thread: http://www.excelforum.com/showthread...hreadid=477853

Debra Dalgleish shows a way at:
http://contextures.com/xlfaqFun.html#SheetName

Simon G wrote:

Hi

Could you tell me how to get the 'tab' name of the excel file shown in a
cell in that
file. Similar to the &[Tab] command in the header or footer.

Thanks you your help.

"Peo Sjoblom" wrote:

One way

=MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,FIND("]",CELL("file
name",A1))-FIND("[",CELL("filename",A1))-1)

the reference to A1 can be any replaced by any cell, even the cell that
holds the formula

--

Regards,

Peo Sjoblom

"milnei" wrote in
message ...

Hi everyone.

I have a very simple request, but I have been unable to find the
answer.

I want to have the filename of the excel file shown in a cell in that
file. Similar to the &[File] command in the header or footer, but
shown in a cell that can then be reffered to in other worksheets.

I hope someone knows the answer.

Cheers

Ian


--
milnei
------------------------------------------------------------------------
milnei's Profile:
http://www.excelforum.com/member.php...o&userid=28235
View this thread: http://www.excelforum.com/showthread...hreadid=477853





--

Dave Peterson

Simon

Sheet name only.

=MID(CELL("Filename",A1),FIND("]",CELL("Filename",A1))+1,255)

For more options see Bob Phillips' site.

http://www.xldynamic.com/source/xld.xlFAQ0002.html


Gord Dibben Excel MVP

On Mon, 12 Dec 2005 02:17:03 -0800, "Simon G" <Simon
wrote:

Hi

Could you tell me how to get the 'tab' name of the excel file shown in a
cell in that
file. Similar to the &[Tab] command in the header or footer.

Thanks you your help.


"Peo Sjoblom" wrote:

One way

=MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,FIND("]",CELL("file
name",A1))-FIND("[",CELL("filename",A1))-1)

the reference to A1 can be any replaced by any cell, even the cell that
holds the formula

--

Regards,

Peo Sjoblom

"milnei" wrote in
message ...

Hi everyone.

I have a very simple request, but I have been unable to find the
answer.

I want to have the filename of the excel file shown in a cell in that
file. Similar to the &[File] command in the header or footer, but
shown in a cell that can then be reffered to in other worksheets.

I hope someone knows the answer.

Cheers

Ian


--
milnei
------------------------------------------------------------------------
milnei's Profile:
http://www.excelforum.com/member.php...o&userid=28235
View this thread: http://www.excelforum.com/showthread...hreadid=477853