Do you want to save the changes you made to 'ABC.xls'?
Put the following macro in the workbook in ThisWorkbook code:
Private Sub Workbook_BeforeClose(Cancel As Boolean)
ThisWorkbook.Saved = True
End Sub
--
Gary''s Student
gsnu200709
"Bob Barnes" wrote:
I'm running Automation from Access-to-Excel.
As the Procedure ends, within Access, I'm getting
the "Subject" Message above. I've run Automation
from Access-to-Excel many times...but now this
message on this one File.
Any way to turn that off?
TIA - Bob
|