Remove formulas and links from 500 workbooks

[Nathan]

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

 

[Nathan]

I knew I forgot something...

Spreadsheets created in Excel 97 but we have all current versions of Excel
if that will make things easier.

Thanks again

Nathan

 

[Ron de Bruin]

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