Extract Data from Multiple Excel Files

[Steven]

I am trying to find a way to use a macro that will enable me to extract
the data in two cells from a worksheet and put it into a new Excel
file. The problem is that I have over 2,000 Excel files and I would
like the program to open up each file and extract the data itself. The
other questions I have is that one of the fields will need to be pasted
as a value since it is a formula in the original worksheet. Is there a
way to do this in Excel?

Thank you.

Steven

 

[Gord Dibben]

See Ron de Bruin's site for copying a range from all files in a folder.

http://www.rondebruin.nl/ado.htm#folder

See other links to varying methods of copying.


Gord Dibben MS Excel MVP