| 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. |
| 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 | |||
Threaded Mode
