Disable Access to Excel backup file in VBA

[Titleist23]

Hi,

Is there some sort of vba code that will stop excel from creating a backup copy of the export file from access?

XLApp.ActiveWorkbook.Close SaveChanges:=True

This code saves and closes the workbook, but it then creates a backup copy. I would like to enter some code so it stops making a backup file.

Thanks

 

[tweedle]

Hmmmmm,
I think you need to perform a .SaveAs to set the CreateBackup attribute...

'untested
XLApp.DisplayAlerts = False
XLApp.ActiveWorkbook.SaveAs XLApp.ActiveWorkbook.FullName, CreateBackup:=False
XLApp.ActiveWorkbook.Close SaveChanges:=True
XLApp.DisplayAlerts = True

 

[Titleist23]

Perfect!!! Thanks buddy