|
How to show Excel Filename in the worksheet
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 -- milnei ------------------------------------------------------------------------ milnei's Profile: http://www.excelforum.com/member.php...o&userid=28235 View this thread: http://www.excelforum.com/showthread...hreadid=477853 |
How to show Excel Filename in the worksheet
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. :confused: 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 |
How to show Excel Filename in the worksheet
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 |
How to show Excel Filename in the worksheet
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. :confused: 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 |
How to show Excel Filename in the worksheet
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. :confused: 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 |
| All times are GMT +1. The time now is 10:08 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com