Macro - SaveCopyAs and Remove VBA Code

Hello,

I need to develop a macro that automatically and silently saves a copy of an Excel Document to a location while stripping the VBA code that copies it. All of this needs to be automated with no user interaction.

This is what I have so far.

ThisWorkbook

Please Login or Register  to view this content.

Module 1

Please Login or Register  to view this content.

This code works great for my needs except the copy opens and attempts to run the macro on the "Loop schedule" and displays a debug error message. I need the copy stripped of the macro so the sheet wont display the error code.

Any help is greatly appreciated.

Thanks

-Matt

Don't know where the Loop Schedule macro is, but consider saving it as an xlsx format file? That will remove any macro in the workbook.

I did try just saving as a .xlsx but everytime I do that I get a "File is corrupt" error when opening the copy.

I noticed that I entered my code wrong. The "This Workbook" code is correct but the Module 1 code should be as below.

Please Login or Register  to view this content.

Try saving it using

Please Login or Register  to view this content.

This should save it into a valid xlsx excel file.

Note: and change the save name to

Please Login or Register  to view this content.