Saving a copy of macro file with no macro(.xlsx format) and do some calculation on saved file

[Niraj Baraili]

Hello Folks,

Returned back after a long time with a question.

I have a macro file called Test.xlsm with sheets Summary, 1, 3. Now, i need to save a copy of Test.xlsm (without
macro i.e.,Test.xlsx) and remove all the formulas from all the sheets and delete sheets 1 and 2.

Googled for help but no luck.

Hope, will get a help from here again.

 

[Ratan Bhushan]

Hello Folks,

Returned back after a long time with a question.

I have a macro file called Test.xlsm with sheets Summary, 1, 3. Now, i need to save a copy of Test.xlsm (without
macro i.e.,Test.xlsx) and remove all the formulas from all the sheets and delete sheets 1 and 2.

Googled for help but no luck.

Hope, will get a help from here again.

PFA...

 

[Niraj Baraili]

Hi Ratan,

Thanks for the reply. I will try to implement this and any challenges let u know.