Thread: Prevent error messagebox when refresing querytable from the web fails
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.excel.links,microsoft.public.excel.misc,microsoft.public.excel.newusers
Ken Johnson
 
Posts: n/a
Default Prevent error messagebox when refresing querytable from the web fails
Hi bzm,
Have you tried "Application.DisplayAlerts = False"?

If this is the solution then make sure it is set back to True before
the code has finished. Excel doesn't reset it itself.
Ken Johnson

Reply With QuoteReply With Quote