I have a question about qy.WorkbookConnection and qy.Name where qy is defined as QueryTable. The qy.WorkbookConnection is 'con2' and the qy.Name is 'Query from MS Access Database_5'.

How can I change the SQL for this specific qy.WorkbookConnection or qy.Name? I can loop through all of the worksheets and all of the querytables searching for the specific connection or name, but I'd like to refer to the WorkbookConnection (or Name) directly by its name. Hope this isn't too confusing.

Thanks