workbook file name in cell
 

I understand how to enter the workbook file name into a header or footer.
Is there a way to enter the workbook file name into a worksheet cell?

Thanks

See

http://www.mcgimpsey.com/excel/formu..._function.html


In article ,
BruceD wrote:

I understand how to enter the workbook file name into a header or footer.
Is there a way to enter the workbook file name into a worksheet cell?

Thanks

One way

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


Regards,

Peo Sjoblom

"BruceD" wrote:

I understand how to enter the workbook file name into a header or footer.
Is there a way to enter the workbook file name into a worksheet cell?

Thanks

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

--

HTH

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


"BruceD" wrote in message
...
I understand how to enter the workbook file name into a header or footer.
Is there a way to enter the workbook file name into a worksheet cell?

Thanks

workbook file name in cell
 

Is it possible to extract JUST the direct parent Folder name from the file
path and place it in a cell? (File Path here is highly variable...actual file
can be many folders deep into the path)
--
THANKS!

Steve


"Bob Phillips" wrote:

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

--

HTH

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


"BruceD" wrote in message
...
I understand how to enter the workbook file name into a header or footer.
Is there a way to enter the workbook file name into a worksheet cell?

Thanks