I want to have VBA that saves a Macro Enabled workbook into a regular workbook. It bugs and says "Run-time error '1004' this extension can not be used with the selected file type. If I change it to "xlsm" it works fine, but that's not what I want. Any help?



Dim newFileName As String
    
       newFileName = "QA Fix It " & Format(Now, "MM-DD HHMM") & ".xlsx"
    
     ActiveWorkbook.SaveAs Filename:="M:\My Folder\Associate QA Reports\Associate QA fix it reports\\" & newFileName