Getting file name in the body of the spreadsheet

G

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
 
G

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)
 
G

Guest

Thanks

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

john said:
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 said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top