When running my VBA in Excel 2007 on a second machine, I get the following error:
Run-time error '430'
"Class does not support Automation or doesn or support expected interface"
When I click Debug, the cursor goes to thie line:
Set MyDatabase = New ADODB.Connection
I must have installed something onto my machine to get it to work, or there is some other configuration difference between my machine (where it works) and the other machine.