SprainBrain
New Member
- Joined
- Jul 22, 2010
- Messages
- 2
Everyday I have to generate an excel report. This report uses spreadsheets that are outputted from a program and are dumped into folders which are organised by date. ie
The report for today would go into a location:
I:\Reports\2010\July\22
The one for the prior day would go into the following location:
I:\Reports\2010\July\21
The names of the reports generated are
"Day 1 Production Report_iegdfjsba3rd.xls"
"Day 1 Inventory Report_kajsgfgsj3as.xls"
"Day 1 Marketing Report_aodjgwuw3bc.xls"
They are all labelled with the same major heading accompanied by a randomly generated code at the end i.e. iegdfjsba3rd
There are about 15 of these reports that I have to relink each day.
Is there a VBA code that I can use to do this for me?
Additionally, I also would have to link a report from the previous day to do a compare e.g. I would have to relink:
"Day 1 Production Report"
for the actual day and the one generated on the prior day.
The report for today would go into a location:
I:\Reports\2010\July\22
The one for the prior day would go into the following location:
I:\Reports\2010\July\21
The names of the reports generated are
"Day 1 Production Report_iegdfjsba3rd.xls"
"Day 1 Inventory Report_kajsgfgsj3as.xls"
"Day 1 Marketing Report_aodjgwuw3bc.xls"
They are all labelled with the same major heading accompanied by a randomly generated code at the end i.e. iegdfjsba3rd
There are about 15 of these reports that I have to relink each day.
Is there a VBA code that I can use to do this for me?
Additionally, I also would have to link a report from the previous day to do a compare e.g. I would have to relink:
"Day 1 Production Report"
for the actual day and the one generated on the prior day.