Hi Nathan

Not possible without opening the files
Look at this example that copy a range to all workbooks in a folder
http://www.rondebruin.nl/copy4.htm

You can change the copy code for code on this page to make values.
http://www.rondebruin.nl/values.htm

If you need help post back

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Nathan" <nathan@123 wrote in message ...
Hi,

I need to know how I can remove formulas and links (and replace with current
values) from 500 workbooks without opening each workbook. I would like to be
able to point to a folder and then let the program do the rest.

We want to archive this data, and with the formulas and links in place it is
a little awkward.

TIA

Nathan