PDA

View Full Version : Using list of locations, open excel files, extract data to new spreasheeet



Jim.h
08-31-2008, 05:52 PM
Backround:
I have ~ 100 budgets with certain named ranges. The budgets are all similar, and each individual budget is it's own workbook, and the named ranges are all the same in each budget like Total_spent, Total_left_to-Spend etc.

The budgets are all located on a shared drive, in individual folders, folders are grouped by entitly name to wit: c:\mydrive\joeblowcorp\bugbudget.xls. I have a list of each of the locations and budget names in text format, which I can import into Excel.

What I need to do:
I need a macro that can extract the location of the budget from the list of location, open the budget, extract the named ranges, write the extracted data to a new spreadsheet, close the budget, and then move on to the next one, until the end of the list is reached.

I am new to trying to write VBA, although I have experience with Excel (just not writing VBA/macros).

Any direction would be appreciated...

Thanks in advance.