asmith
03-07-2011, 10:05 AM
I am developing an Excel file that runs a simple SQL query based on a few parameters and then puts the data into a spreadsheet. I have all the VBA working just fine. The problem is when I send it out to be tested by another user on another computer, they get a run-time error. The specific message is "Run-Time Error 430: Class does not support automation or does not support expected interface". The way that I resolve this is by going into the VBA, then doing some minor change, then reversing it, then saving it, and it works again. I'm pretty sure that somewhere along the lines the link to the ADODB library is being broken, but I don't know how to get it so that I don't have to do this in the first place. There are some subtle differences between my development machine and those used by our users which are as follows.
Development:
Windows 7 SP1 Professional x64
Office 2010
Client:
Windows 7 Professional x86
Office 2010
I would not think that there would be that this would cause any issues though. Additionally, I am using ADO 2.8. I have also tried this with version 2.7 and got the same results.
Does anyone have any idea how to fix this?
Thanks!
Development:
Windows 7 SP1 Professional x64
Office 2010
Client:
Windows 7 Professional x86
Office 2010
I would not think that there would be that this would cause any issues though. Additionally, I am using ADO 2.8. I have also tried this with version 2.7 and got the same results.
Does anyone have any idea how to fix this?
Thanks!