Saving changes to Excel file 1

[JR2913]

I am amending data in an Excel spreadsheet from within Access using VBA and then saving the updated file using

xlBook1.SaveAs Filename:=Dir & "\tblChildData.xls", FileFormat:=xlNormal, CreateBackup:=False


With warnings already turned off, is there a way of amending the syntax to prevent the user being asked if they want to save the updated file?

Many thanks

John R

 

[mpastore]

I think there is a property at the excel object level called displayalerts, set this to false...

objExcel.DisplayAlerts = false (or No)

Mike Pastore

Hats off to (Roy) Harper

 

[sfm6s524]

You could also try using:

xlBook1.SaveCopyAs Filename:=Dir & "\tblChildData.xls"

 

[JR2913]

Thanks Mike - works a treat now - have a star.

Sorry smm6s524 - tried this but it didn't hide the confirmation message.

John R