Take a look at

http://www.xldynamic.com/source/xld.xlFAQ0002.html
Excel FAQs - File Path, File and Worksheet Names

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Bhupinder Rayat" wrote in
message ...
Is there any way of displaying the filename of the spreadsheet in a cell
within the workbook?

If not then how simple is it to create a user defined function to do this?

Any help would be much appreciated.

Thanks,

Bhupinder Rayat