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.

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.