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

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

On 2 Nov 2006 07:26:18 -0800, "Steven" wrote:

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