title: How to reference Access query defs from Excel?
body: <p>I have a need to change the SQL of a query saved in Access from Excel and it must use late binding.</p>
  
  <p>Specifically I'm building SQL strings in Excel VBA featuring a number of parameters provided by the user in Excel and querying the database via an ADODB connection. I have constructed core queries in the database which do most of the work so I can keep my SQL strings and the amount of data returned light on the Excel end.</p>
  
  <p>Mostly this works fine but some of those core queries rely on other queries nested several levels deep, and some of the parameters I need to supply are around data in those parent queries. So, I'm thinking I need to temporarily amend the SQL of those parent queries before running my main code (unless anyone has another idea?). I know how to change the SQL for a queryDef in Access, but not how to get to the queryDefs from Excel.</p>
  
  <p>So TL:DR - how can I get a handle on the queryDefs in an Access accdb from Excel?</p>
  
  <p>Thanks.</p>