title: ADODB connection from VBA stopped working
body: <p>We've got an Exccel spreadsheet used to manage the rota for the out of hours support engineers.  A while back, I added a bit of VBA code which automatically diverts the support phone numbers to the engineer's phone out of hours.</p>
  
  <p>It does this by connecting to a database run by the phone providers, and updating the divert number.</p>
  
  <p>This afternoon, it is suddenly not working on the central server:</p>
  
  <pre><code>Dim Db As ADODB.Connection
  
  Sub ConnectDatabase()
    Set Db = New ADODB.Connection
    Db.Open "SupportMobileDb"
  End Sub
  </code></pre>
  
  <p>The code stops at the <code>New ADODB.Connection</code> line, and reports:</p>
  
  <pre><code>Run-time error '430':
  Class does not support Automation or does not support expected
  interface
  </code></pre>
  
  <p>I can still run the macro on my laptop, and it works correctly.  And on the central server, I can still use Excel, and connect to the datasource correctly.  It just won't work through VBA any more on this server.</p>
  
  <p>The macro ran correctly at 9am and diverted all the phones to the office, but the 5pm divert to staff macro didn't work.  I can't see that Windows was updated today, or really any other changes at all.</p>
  
  <p>Has anyone seen this problem before?</p>