VBA - Can't save .xlsm file to .xlsx - runtime error 1004

[soundtrackz]

I have many macros with this and it suddenly stopped working - displaying runtime error 1004 - can't save from xlsm file to macro-free file.
Any idea, what happened?

Sub Saving()
    Dim strName As String

    Application.DisplayAlerts = False
    
    strName = ThisWorkbook.Path & "\SomeName.xlsx"
    ThisWorkbook.SaveAs Filename:=strName, FileFormat:=xlOpenXMLWorkbook
    
    Application.DisplayAlerts = True
End Sub

 

[Fluff]

I'm on Microsoft 365 MSO (Version 2311 Build 16.0.17029.20108) 32-bit & I checked yesterday that I'm fully up to date.

 

[RoryA]

It fails for me on 2401, so it would appear to be an Insiders/beta issue.

 

[RoryA]

I've submitted feedback to them about it.

 

[Fluff]

In this thread VB projects and XLM sheets cannot be saved in a macro-free workbook @Jeffrey Mahoney has the same problem & he's not on the beta channel.

 

[RoryA]

The only commonality I can see then is the 64bit one (mine is also 64 bit). Without the displayalerts line, what dialog do you see? The old one with 'Yes' as the default option?

Edit: ignore that - looks like Domenic has the problem on 32 bit.

 

[Fluff]

Without the displayalerts line, what dialog do you see? The old one with 'Yes' as the default option?

Yes I do.