Using parameters to use different source files dependant on the date.

  • Thread starter Thread starter stuckupnorth
  • Start date Start date
S

stuckupnorth

I am creating excel worksheets using webtrends. I am trying to get thi
information into a monthly update report excel spreadsheet with a ne
row of information for each month. This would all work fine if I coul
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 tha
specific file. Can anyone please help me. I'm sure its possible someho
and its driving me insane
 
Try:

=INDIRECT("'e:\reports\monthly\["&TEXT(TODAY(),"yyyymmdd")&".XLS]sheet1'!C21")

you may need to adjust the date format.

HTH
Jean-Guy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

converting dates from file 3
Date format to Text Date for use in Mail Merge 3
Excel 2003 help 1
different values depending on how text file is opened 6
International Date formatting 4
Sort month/date/year data using month and date only 6
Grouping Date Fields in Pivot Table 2
Using Worksheet as Data Source 1

Back
Top