The "problem" with MS-Query and Excel 2007 is that instead of downloading the query to a data range, it downloads it to an Excel 2007 TABLE. You can convert the table to a data range if you want to remove the query.
I have the same issue. So I create / modify the query on a machine running Excel 2003 - this version works with both 2003 / 2007 and allows my 2003 legacy code to work. The legacy code fails if I try to run it against a query that was edited or created in 2007.
---
frmsrcurl:
http://msgroups.net/microsoft.public...-to-Excel-2007