Thread: excel 2007 query question
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ed Ferrero[_3_] Ed Ferrero[_3_] is offline
external usenet poster
  
Posts: 108
Default excel 2007 query question
Hi Gary,

Try this,
ws.Range("A6").ListObject.QueryTable.Refresh BackgroundQuery:=False

this works in excel 2003, but in excel 2007, the following line debugs.

ws.Range("A6").QueryTable.Refresh BackgroundQuery:=False

is there a different syntax in 2007

Reply With QuoteReply With Quote