Code to supress warnings in excel

ZMAN2

Registered User.
Local time
Today, 00:22
Joined
May 6, 2003
Messages
37
Does anyone know of code that supresses warnings in excel by way of access. I'm looking for something like setwarnings=false in access. Specifically, I have some code in access that manipulates excel and in the process also deletes a few sheets in a workbook and I would like to supress the warnings associated with the deletion. I appreciate any help on this matter. Great Forum!
 
Within Excel, it's Application.DisplayAlerts = False.
Should be like...
xlApp.DisplayAlerts = False
...where xlApp is your hook to the Excel Application.
 
Thanks

I appreciate your response and I'll give it a try. :)
 

Users who are viewing this thread

Back
Top Bottom