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

 

[MARK858]

Exactly what I stated there are various temp files appearing (I can see them running on the desktop) since using the last version of the code with the Sendkeys.
It is actually happening with the code without the sendkeys and displayalerts since running it, just not with saving manually.
I am going to attempt a repair to try and sort it.

 

[johnnyL]

Yes, please let us know because I see no reason why temp files would be running as a result of using SendKeys.

 

[MARK858]

Only started since running sendkeys

 

[MARK858]

Deleted the files created, ran a repair and done a restart and appears to have cleared the issue

 

[johnnyL]

Thank you for the update.