Thread: Insert a filename that will automatically update if changed.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JE McGimpsey JE McGimpsey is offline
external usenet poster
  
Posts: 4,624
Default Insert a filename that will automatically update if changed.
See

http://mcgimpsey.com/excel/formulae/cell_function.html

In article ,
JR wrote:

I have temporary file names that I need to enter into Excel, but I know later
on they will change. Is there any way to automate this so that when the files
are renamed the spreadsheet will automatically update?

This would be very helpful.
Thanks,
Reply With QuoteReply With Quote