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

 

[Jeffrey Mahoney]

Microsoft® Excel® for Microsoft 365 MSO (Version 2311 Build 16.0.17029.20028) 64-bit

 

[Fluff]

I'm on Microsoft 365 MSO (Version 2311 Build 16.0.17029.20108) 32-bit

 

[Domenic]

I'm on Microsoft® Excel® for Microsoft 365 MSO (Version 2311 Build 16.0.17029.20068) 32-bit

 

[MARK858]

I get the same error with
Microsoft® Excel® for Microsoft 365 MSO (Version 2312 Build 16.0.17126.20014) 64-bit
Literally just updated it. to the above version

 

[Domenic]

I have just updated it and still get the same error . . .

Microsoft® Excel® for Microsoft 365 MSO (Version 2311 Build 16.0.17029.20108) 32-bit

 

[RoryA]

What dialog do you get without the displayalerts lines in? Is it the old one that defaults to Yes as the response, or the new one that defaults to Go Back?

 

[Jeffrey Mahoney]

Is the VBA portion a separate build from the spreadsheet portion? Is there a DLL that needs an update that controls the DisplayAlerts?

 

[MARK858]

What dialog do you get without the displayalerts lines in? Is it the old one that defaults to Yes as the response, or the new one that defaults to Go Back?

I get

 

[Jeffrey Mahoney]

 

[Domenic]

What dialog do you get without the displayalerts lines in? Is it the old one that defaults to Yes as the response, or the new one that defaults to Go Back?

I get the same as Mark and Jeffrey . . .