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.
Bookmarks