Turing off EXCEL warning message from VB in ACCESS

  • Thread starter Thread starter dreeves
  • Start date Start date
D

dreeves

i am opening an excel workbook from within a VB module
that runs automatically. When I am done extracting my data
from the spreadsheets and want to close the workbook, I
sometimes get a warning message about saving the workbook
before closing. This stops the process. Is there any way
to supress the message? I have tried "DoCmd.SetWarnings
False" which works for ACCESS messages only. The warning
message seems to be coming from EXCEL. So I
tried "Application.DisplayAlerts = False", but I get a
compile error. Anyone have any ideas?
 
Back
Top