View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ardus Petus Ardus Petus is offline
external usenet poster
 
Posts: 718
Default Insert file name into sheet

=CELL("flename")

HTH
--
AP

"Darin Kramer" a écrit dans le message de
...


Hi There,

I want to have the file name appear in cell a5, on a sheet (say called
"test"). It needs to be able to update when users changes file name..

Any ideas....

Thanks

D

*** Sent via Developersdex http://www.developersdex.com ***