Excel VBA Parameterized Query

[KG Old Wolf]

I've created a VBA-based query that uses a worksheet cell value as an input parameter. The query uses an Access database and returns with the desired record(s). It works just fine BUT....I get a new "Connection" listed in my Data - Connections and a new "ExternalData" range name listed in Formula - Name Manager.

Through VBA I create the range name I want and would like to ensure the extraneous connections and ExternalData ranges aren't created.
I assume there are .Member commands that will suppress this but I can't seem to find them.... any pointers will be appreciated.

Thanks

 

[xenou]

I'm not sure I want to debug the recommendation of an unknown MS tech telling us to do something that (apparently) doesn't work. Are you sure you can't just do this the normal way?