VBA Excel 2007 and MS-Query

[JustATheory]

Greetings,

In 2003, I was able to record a query and place it within a macro and it ran everytime. In 2007, I get an error 9, due to an .ODBC connection. Is there something in 2007, that I should switch on or off. It also records much more information, is there an area to switch to a previous mode?

Any help is greatly appreciated!

Thanks,
Andy

 

[SkipVought]

Andy,

Please post your macro.

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}