Thread: Refresh Query on open failing
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
ward376 ward376 is offline
external usenet poster
  
Posts: 360
Default Refresh Query on open failing
Try referring to the query table rather than a range:

yoursheet.QueryTables(1).Refresh BackgroundQuery:=False

Cliff Edwards
Reply With QuoteReply With Quote