View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sharky23
 
Posts: n/a
Default Intranet Excel File...Changing Name

I need to link to in excel file on my office intranet. The filename changes
daily when reports are run but I haven't figured out how to link to it.

http://us.com/reports/production/myfile_20060430.xls

This is the only file in that folder with that name, so if I can get excel
to ignore the date on the end, I would be fine.

All assistance is greatly appreciated.