How to show Excel Filename in the worksheet

M

milnei

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. :confused:

Cheers

Ian
 
P

Peo Sjoblom

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
 
S

Simon G

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 said:
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 said:
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. :confused:

Cheers

Ian
Click to expand...
Click to expand...
 
D

Dave Peterson

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

Simon said:
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 said:
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 said:
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. :confused:

Cheers

Ian
Click to expand...
Click to expand...
Click to expand...
 
G

Gord Dibben

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
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 said:
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 said:
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. :confused:

Cheers

Ian
Click to expand...
Click to expand...
Click to expand...
 
Top