View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
stuckupnorth
 
Posts: n/a
Default Using parameters to use different source files dependant on the date.


I am creating excel worksheets using webtrends. I am trying to get this
information into a monthly update report excel spreadsheet with a new
row of information for each month. This would all work fine if I could
state the source file as filename "-todaysdate-".
I have tried =('e:\reports\monthly\[%yyyy%mm%dd%.XLS]sheet1'!C21)
This does not work...
Once linked to a source file the formula changes to point to that
specific file. Can anyone please help me. I'm sure its possible somehow
and its driving me insane.


--
stuckupnorth
------------------------------------------------------------------------
stuckupnorth's Profile: http://www.excelforum.com/member.php...o&userid=31330
View this thread: http://www.excelforum.com/showthread...hreadid=510129