Cell equal to File Name

[Pedro Serra]

Is there a way to put the name of the excel file in a worksheet?

Thanks

 

[Ron de Bruin]

Hi Pedro

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

 

[Sloth]

=MID(CELL("filename",A1),1+FIND("[",CELL("filename",A1)),FIND(".",CELL("filename",A1))-FIND("[",CELL("filename",A1))-1)

This only works if you have saved the file at least once.

 

[Pedro Serra]

Thanks

"Ron de Bruin" escreveu:

Hi Pedro

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

 

[Pedro Serra]

Thanks

"Sloth" escreveu:

=MID(CELL("filename",A1),1+FIND("[",CELL("filename",A1)),FIND(".",CELL("filename",A1))-FIND("[",CELL("filename",A1))-1)

This only works if you have saved the file at least once.

Is there a way to put the name of the excel file in a worksheet?

Thanks