Saving xlsm file as xlsx while running macro

**happygilmore** · 10-29-2012, 12:32 PM

Hi,

I have a macro in .xlsm that users run and then the last step is to save the file as .xlsx. The problem is that I keep getting a run time error "Method "SaveAs" of object '_Workbook' failed". Users are to give their file a unique name.

I have researched and tried many solutions to no avail. My original macro selected the tabs needed and moved them to a new file. The problem that started happening is that if there is too much data being copied/moved, then I got a run time error. My new solution, should it ever work, is to save the .xlsm file as .xlsx and delete the tabs that are not needed.

What am I doing wrong?
Please help.

Please Login or Register  to view this content.

Thank you!

**Winon** · 10-29-2012, 12:42 PM

Hello happygilmore,

Welcome to the Forum!

You cannot save a Macro enabled WorkBook in a xlsx Format with any other name whilst it contains Macros.

**happygilmore** · 10-29-2012, 02:06 PM

Thanks Winon.

The macros are not needed in the new .xlsx file. Am I still out of luck? I'm thinking so since I am running a macro yet trying to make a xlsx file.

Thank you for your time.

**Winon** · 10-29-2012, 02:32 PM

Hello happygilmore,

To be honest, I truly don't know if it is at all possible via VBA. I tend to believe that you would have to do it manually by removing all the code from the WorkBook, and only then save it as a xlsx.

Sorry 'bout that.