Excel 2007 & 2003 Data Queries Q

  • Thread starter Thread starter Seanie
  • Start date Start date
S

Seanie

I hope below will make sense. I'm trying to create a Data Query from
an External source (using Excel 2007). I've done this many times under
Excel 2003. I've managed to pull in the data, but it appears as a
table. My Excel 2003 queries were not pulled in like a table. Is this
how 2007 does it now?

Also when I want to refresh the data, I usually run below

Range("A1").Select
Selection.QueryTable.Refresh BackgroundQuery:=False

But under the Table query in Excel I have to run below

Range("I1").Select
Selection.ListObject.QueryTable.Refresh BackgroundQuery:=False

Is this how it is under Excel 2007, or can I change it, the way I'm
used to under X2003? If so how can I amend, without having to create
the query from scratch?

Thanks
 
Back
Top