Thread: Cell equal to File Name
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Pedro Serra Pedro Serra is offline
external usenet poster
  
Posts: 19
Default Cell equal to File Name
Thanks

"Sloth" escreveu:

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

This only works if you have saved the file at least once.

"Pedro Serra" wrote:

Is there a way to put the name of the excel file in a worksheet?

Thanks
Reply With QuoteReply With Quote