Make Duplicate Copy with Values instead of Formulas

[caper11752]

Hello,

I have a massive workbook that is updated daily using Access to export new data. I was wondering how I could go about making an exact copy of my original, except I'd like to replace the formulas with the cell values in the new copy. Then I could distribute the copy to the parties that use this report. Any suggestions?

 

[SkipVought]

In your COPY of the workbook

dim ws as worksheet

for each ws in activeworkbook.worksheets
  with ws
    .copy
    .[A1].pastespecial xlpastevalues
  end with
next

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]