Programming MSAccess ----> Excel

[MyerK]

I remember reading that there is a property that can be set when you open a spreadsheet that suppresses user qustions such as 'Do you want to save?'.

Don't remember what it is.

Anybody remember?

Thanks

 

[SkipVought]

Hi,

In Excel its

Application.DisplayAlerts = False

Skip,

http://www.TheOfficeExperts.com

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[drctx]

i think docmd.setwarnings is what you would use. just remember to do error handling.

' turn warnings off
docmd.setwarnings false

' *** code here ***

' turn warnings on
docmd.setwarnings true

 

[MyerK]

Thanks a lot.

MK