VBA code remove all formulas from entire workbook without losing original file

Hello Expert,

I have a VBA code that remove all formulas from the entire workbook. However, it is now working on the file where the code will be executed. Is it possible that if we select a file that needs all of the formulas removed, it will not spoil that file and instead make a copy without the formulas in the preset folder or the same directory, depending on which choice we choose? Please assist me if this is possible. Thank you in advance.

Please Login or Register  to view this content.

Actually, I am new to VBA and am learning it on a daily basis. In the code, I've made a few adjustments. However, it is functional, but the file extension is changing. Can you assist me in resolving this issue?

Please Login or Register  to view this content.

I have changed the code:

Please Login or Register  to view this content.

But, the file name still has the extension name prior to the date; how can this be removed? Please suggest.

Hi, cytop!

Thank you for responding once again. However, as you can see in the screenshot of the file name, the option to hide file extensions is already disabled. The extension appears before the date, rather than at the end of the name.

I can't help further.

Okay, Thank you so much for your assistance.

Hi All,

I have found the solution on google. Here is the final code:

Please Login or Register  to view this content.