View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jean-Paul De Winter Jean-Paul De Winter is offline
external usenet poster
 
Posts: 46
Default Excel filename into cell

Thanks for the reply...
Tried to enter it in cell A1 but got an error ....
JP
"Frank Kabel" schreef in bericht
...
Hi
Use (just insert the formulas as-is. Note: the workbook
has to be saved before)
=MID(CELL("filename",A1),FIND("[",CELL("filename",A1),1)
+1,FIND("]",CELL("filename",A1),1)-FIND("[",CELL
("filename",A1),1)-1)

-----Original Message-----
Hi,

Is it possible to get the filename of an excel-file into

cel A1?

Thanks


.