Home |
Search |
Today's Posts |
#1
|
|||
|
|||
insert file name
Hi,
Is there a way to program a cell to see and display the current name of it's Excel file? Similar to the option displaying it in the header or footer, I would like to display the file name in a cell of the spreadsheet itself. Any help would be appreciated. Thanks in advance, Mark |
#2
|
|||
|
|||
Mark Filename =MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,(FIND("]",CELL("filename",A1))+1)-FIND("[",CELL("filename",A1))-2) Sheet name =MID(CELL("filename",A1),FIND("]",CELL("filename",A1),1)+1,255) Full Address =CELL("filename",A1) Bob On Tue, 03 May 2005 11:42:28 -0500, Mark wrote: Hi, Is there a way to program a cell to see and display the current name of it's Excel file? Similar to the option displaying it in the header or footer, I would like to display the file name in a cell of the spreadsheet itself. Any help would be appreciated. Thanks in advance, Mark |
#3
|
|||
|
|||
=CELL("filename")
"Mark" wrote: Hi, Is there a way to program a cell to see and display the current name of it's Excel file? Similar to the option displaying it in the header or footer, I would like to display the file name in a cell of the spreadsheet itself. Any help would be appreciated. Thanks in advance, Mark |
#4
|
|||
|
|||
Mark,
Take a look at http://www.xldynamic.com/source/xld.xlFAQ0002.html -- HTH RP (remove nothere from the email address if mailing direct) "Mark" wrote in message ... Hi, Is there a way to program a cell to see and display the current name of it's Excel file? Similar to the option displaying it in the header or footer, I would like to display the file name in a cell of the spreadsheet itself. Any help would be appreciated. Thanks in advance, Mark |
#5
|
|||
|
|||
=CELL("filename") Careful, if you don't use a cell reference on the sheet this formula will show the path/file/sheet you were on when you last recalculated. Also, switching back to the sheet or printing will not automatically recalculate. "Mark" wrote: Hi, Is there a way to program a cell to see and display the current name of it's Excel file? Similar to the option displaying it in the header or footer, I would like to display the file name in a cell of the spreadsheet itself. Any help would be appreciated. Thanks in advance, Mark |
#6
|
|||
|
|||
Excellent point!
"Bob Tarburton" wrote: =CELL("filename") Careful, if you don't use a cell reference on the sheet this formula will show the path/file/sheet you were on when you last recalculated. Also, switching back to the sheet or printing will not automatically recalculate. "Mark" wrote: Hi, Is there a way to program a cell to see and display the current name of it's Excel file? Similar to the option displaying it in the header or footer, I would like to display the file name in a cell of the spreadsheet itself. Any help would be appreciated. Thanks in advance, Mark |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
insert the date the file was last modified | Excel Discussion (Misc queries) | |||
Challenging Charting | Charts and Charting in Excel | |||
insert image in head excel file? | Excel Discussion (Misc queries) | |||
How do I insert an Excel file into a PowerPoint Presentation slid. | Excel Worksheet Functions | |||
How do I insert an Excel file into a PowerPoint Presentation slid. | Excel Discussion (Misc queries) |