new to VBA...loop?
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. |
new to VBA...loop?
Try this example
http://www.rondebruin.nl/copy3.htm -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl "bluebanker" wrote in message ... 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. |
All times are GMT +1. The time now is 05:19 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com