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