Relink Same Mame Multiple Spreadsheets from different locations to a Main Spreadsheet

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.

:confused:
 

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

Watch MrExcel Video

Forum statistics

Threads
1,133,376
Messages
5,658,456
Members
418,445
Latest member
TMannny

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top