View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default 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