Delete All the Formulas after 2 times open excel file

[chethan1333]

HI,I want to VBA code for Delete All the Formulas in excel after 2 times open excel file

.. Please help

[kev_]

You could try something like this.
It creates a copy of the file with values only instead of formulas

Create a new sheet and name it XXX
- its only purpose is to keep count
- while testing you may want to keep resetting XXX cell A1 back to zero!

In the ThisWorkbook module

Please Login or Register  to view this content.

The above macro saves as .xlsm, use this method to save as .xlsx (adapt to suit)
ActiveWorkbook.SaveAs Filename:=newFileFullName, FileFormat:=xlOpenXMLWorkbook