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 Ken Johnson is offline
external usenet poster
 
Posts: 1,073
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