Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VBA - extract a value from many spreadsheets
I have several thousand spreadsheets, one each in a path (example) of
\level1\level2\Year\Month\Folder\file.xls. I need a macro that will open each file.xls, copy cell G9 and past it in a "summary" file cell A1. Then go to next file, copy G9 into A2, etc. The copy/paste part seems pretty straightforward, and loop is obvious, but I have no idea how to write code that would generically do this on every xls file in this many branched path tree. Is it possible? I'm a VBA novice, and appreciate any help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
VBA - extract a value from many spreadsheets
Hi Mike
You can also create links http://www.rondebruin.nl/summary2.htm Or if you want to open the files see http://www.rondebruin.nl/copy3.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm wrote in message oups.com... I have several thousand spreadsheets, one each in a path (example) of \level1\level2\Year\Month\Folder\file.xls. I need a macro that will open each file.xls, copy cell G9 and past it in a "summary" file cell A1. Then go to next file, copy G9 into A2, etc. The copy/paste part seems pretty straightforward, and loop is obvious, but I have no idea how to write code that would generically do this on every xls file in this many branched path tree. Is it possible? I'm a VBA novice, and appreciate any help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can Excel Spreadsheets be saved as Microsoft Works spreadsheets? | Excel Discussion (Misc queries) | |||
How can I extract each Max key value ? | New Users to Excel | |||
Fomula to extract from other spreadsheets | New Users to Excel | |||
Extract Unique Values, Then Extract Again to Remove Suffixes | Excel Discussion (Misc queries) | |||
How to extract cells from multiple spreadsheets into one new spreadsheet | New Users to Excel |