Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't paste cell copied from hyperlinked file | Excel Worksheet Functions | |||
Change workbook sheet reference using cell A1 to change a vairable | Excel Worksheet Functions | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Using Jet to read excel file returns blank for last cell - sometim | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |