Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find loop doesn't loop | Excel Discussion (Misc queries) | |||
need help with loop ? again | Excel Discussion (Misc queries) | |||
VBA Loop Help | Excel Discussion (Misc queries) | |||
loop | Excel Discussion (Misc queries) | |||
Help with Do...Loop | Excel Discussion (Misc queries) |