Excel 2010 Queries

[kgkev]

Since updating to 2010 I am having trouble automating my sql queries.

In the past I would create the query and then use.

.QueryTable.Refresh BackgroundQuery:=False

this still works with all my old queries, but if I create a new query I have to use

.ListObject.QueryTable.Refresh BackgroundQuery:=False

This solved problem 1, Now I want to copy and paste some of the data and get a message saying...

RUN-TIME Error '1004':
Cannot complete operation: A table cannot overlap with a pivottable report, query results, a table, merged cells or an XML Mapping.

My code worked fine before, Is it possible to recreate my query the old way?

I hope you understand what I mean...

I sort of want to "Convert to Range" or ".unlist" without losing the query.