Macro running multiple queries

  • Thread starter Thread starter Pat
  • Start date Start date
P

Pat

I have a macro that runs several queries but I don not
want to receive the message that so many items will be
appended and then having to hit ok - Is there a way to
hide these messages and not have to say ok?

Thanks.

Pat
 
At the start of the macro turn "setwarnings" to "off".

I recommend turning back to "on" at the end of macro though.
 
Back
Top