title: How do I make an ADODB.Connection Persistent in VBA in Excel?
body: <p>I have an Excel spreadsheet that needs to display data from our SQL database.</p>
  
  <p>I am storing the results of a slow query in a temporary table and want to be able to access those results repeatedly without having to rerun the slow query.</p>
  
  <p>I am using an ADODB.Connection in VBA to connect to our SQL database and retrieve information. I want to open a connection once and use that session across various macros for as long as the user is using the spreadsheet. I can't find any way to make the connection persistent, so it always closes once I exit the macro that opened it and I lose any temporary tables that I created.</p>