Getting file name in the body of the spreadsheet

[Guest]

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

 

[Guest]

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)

 

[Ron de Bruin]

Hi Curtis

See
http://www.xldynamic.com/source/xld.xlFAQ0002.html

 

[Guest]

Thanks

Is there a waty just to get the filename only with out the path. The formula
below also gives the path

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)

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