Turing off EXCEL warning message from VB in ACCESS

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

display warning message 1
Delte sheets in Excel from Access 1
EXCEL "workbook contains macros" warning message 1
turning off action queries 3
Saving Excel from Access 1
Using Call Shell to open Excel Workbook within Access 2003, SP2 Ve 1
Turing off warnings 2
Deleting sheet from a template 2

Top