| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Getting file name in the body of the spreadsheet
Is there a command that I could that would paste the name of an excel
workbook and worksheet into the body of the spreadsheet, say cell a4 and a5 Simular to when you print the file name and tab name when printing Thanks ce |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Getting file name in the body of the spreadsheet
try =CELL("filename",A1) for all the info or
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255) if you just want the sheet name. -- John MOS Master Instructor Office 2000, 2002 & 2003 Please reply & rate any replies you get Ice Hockey rules (especially the Wightlink Raiders) "Curtis" wrote: Is there a command that I could that would paste the name of an excel workbook and worksheet into the body of the spreadsheet, say cell a4 and a5 Simular to when you print the file name and tab name when printing Thanks ce |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Getting file name in the body of the spreadsheet
Thanks
Is there a waty just to get the filename only with out the path. The formula below also gives the path "john" wrote: try =CELL("filename",A1) for all the info or =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255) if you just want the sheet name. -- John MOS Master Instructor Office 2000, 2002 & 2003 Please reply & rate any replies you get Ice Hockey rules (especially the Wightlink Raiders) "Curtis" wrote: Is there a command that I could that would paste the name of an excel workbook and worksheet into the body of the spreadsheet, say cell a4 and a5 Simular to when you print the file name and tab name when printing Thanks ce |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Getting file name in the body of the spreadsheet
Hi Curtis
See http://www.xldynamic.com/source/xld.xlFAQ0002.html -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Curtis" wrote in message ... Is there a command that I could that would paste the name of an excel workbook and worksheet into the body of the spreadsheet, say cell a4 and a5 Simular to when you print the file name and tab name when printing Thanks ce |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I add an autoupdate file name insert to the document body? | Excel Discussion (Misc queries) | |||
| Any body help me out with this? | Excel Discussion (Misc queries) | |||
| email excel spreadsheet as body of message, not as attachment | Excel Discussion (Misc queries) | |||
| When sending file via email, cannot paste Excel data into body of letter. | Excel Discussion (Misc queries) | |||
| I need to download an exel spreadsheet file. (file extension :xls) | Excel Discussion (Misc queries) | |||
Hybrid Mode
