|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 3rd, 2005, 05:42 PM
|
|||
|
|||
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
May 3rd, 2005, 06:17 PM
|
|||
|
|||
|
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
May 3rd, 2005, 06:21 PM
|
|||
|
|||
|
=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
May 3rd, 2005, 06:23 PM
|
|||
|
|||
|
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 news  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
May 3rd, 2005, 06:26 PM
|
|||
|
|||
|
=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
May 3rd, 2005, 06:41 PM
|
|||
|
|||
|
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
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Challenging Charting | C TO | Charts and Charting | 0 | January 17th, 2005 06:57 PM |
| Jet35.sp3 | doglover | Database Design | 3 | August 26th, 2004 04:41 PM |
| Continual Error 1321 Trying to Install Office 2003 | Chad Harris | General Discussions | 9 | June 11th, 2004 08:19 AM |
| Unsafe Attachments | Ron | Installation & Setup | 2 | June 9th, 2004 01:55 AM |
| GPO Office 2003 | Tony | Setup, Installing & Configuration | 1 | May 12th, 2004 10:42 AM |
Linear Mode
