I had exactly the same problem where message boxs were in the open
workbook event, however it is very easy to overcome just disable the
events. The code is:

Application.EnableEvents = False

Just remember to switch them back on at the end of your code!

I hope that helps.

James

(Spammastergrand) wrote in message ...
I have a program that collects information on Access or Excel files from
Access. But when run it sometimes brings up splashscreens or something that
requires action, which I don;t want in a batch process.

Is there a way of supressing it? Application.displayalerts doesn't work.
Can you supress code being run in a workbook open event?

I'm using one workbook to open others. Can I open another in a way that
prevents that workbooks open event from running a splashscreen or other code?