new to VBA...loop?

  • Thread starter Thread starter bluebanker
  • Start date Start date
B

bluebanker

Every day for the last 3 years, my co-worker has saved a file with
similar information under the same dirctory, naming it after the day
(20030619.xls). How do I pull all this data in on one spreadsheet, I
just cells A4:H8 from everyday of the past 3 years to appear on one
sheet. Totally new to VBA. Is there a way to save all these workbooks
as tabs (by day) or a simpler way?

Thanks for your help.
 
Back
Top