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

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

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

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