VB projects and XLM sheets cannot be saved in a macro-free workbook

[Jeffrey Mahoney]

I've had this macro running for a couple years with no issue. It basically creates a copy of a sheet in a new WB and then saves it as a .XLSX. With suppressing the alerts it has worked fine until yesterday. I did inspect my file name and is properly formed with .XLSX at the end.

This was posted with no response yet:
Redirecting

Is this a new bug in Excel?

Application.DisplayAlerts = False 'Don't display warning about changing file extension
NewWB.SaveAs Filename:=NewPathFile, FileFormat:=xlOpenXMLWorkbook 'Save to xlsx
Application.DisplayAlerts = True

 

[Fluff]

I don't have autosave turned on, so maybe that's the culprit.

 

[MARK858]

I don't have autosave turned on, so maybe that's the culprit.

I get the same error with Autosave turned off

 

[RoryA]

Which version of Windows are we all on?

That dialog certainly explains the problem, but I'm not sure why not everyone has the same one.

 

[MARK858]

I'm still on Windows 10

 

[Domenic]

I'm on Windows 11 . . .

 

[RoryA]

I don't get the issue on W10 with version 2309 build 16827.20278 64bit
I do on W11 version 2401 build 17130.20000 64bit.

 

[Fluff]

Win 10 home version 22H2 build 19045.3693

 

[Jeffrey Mahoney]

Windows 11 Enterprise Version 23H2, OS Build 22631.2715

 

[johnnyL]

As much as it is frowned upon, you should be able to add a line for sendkeys to keep the code working.

Just change:

    Application.DisplayAlerts = False

to the following:

    SendKeys "{Tab 3}" & "{Enter}"
    Application.DisplayAlerts = False

That should work for the newest 'bugged' versions as well as the versions that weren't affected.

 

[MARK858]

you should be able to add a line for sendkeys to keep the code working.