Create a new file without formulas or auto-update

Howdy!

I wrote a code to autosave my files while also creating historical ones. The issue that I just realized is that some of those formulas reference other spreadsheets (and yes, this is part of the plan) and they autoupdate essentially making the whole point of creating a historical file useless. Is there a way to ensure that the spreadsheet creates a copy without the formulas?

Please Login or Register  to view this content.

EDIT TO THIS REQUEST:

The historical file also keeps this auto-save feature. Anyway to create the historical file without them? I'm not sure if this is possible or if it would work, but maybe when saving I could delete all macros and formulas and keep the values? Anyhow, any help is appreciated.

EDIT #2:

I've made a few changes to the code and now I'm getting error 1004 when I try to change the file format.... Why?

Please Login or Register  to view this content.

Not SPAM at all, and thank you so much for bothering to come back and share a solution.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.