I developed a Microsoft Access 2003 application using VBA approximately 2 years ago. At the time both my client and I were running Windows XP Pro SP3. The Access application was successfully developed and delivered. All was well.
Last month the same client asked for changes on this same Access application. I since updated my operating system to Windows 7 Ultimate. I still used Microsoft Office 2003. I received an error from Access:
Run-time error '430': Class does not support Automation or does not support expected interface
The offending statement was:
cnnExcel.Open "Provider=Microsoft.jet.OLEDB.4.0;" & _
"Data Source=" & strSelectedPath & _
";Extended Properties=""Excel 8.0;"""
The Access module references under Windows XP SP3 and under Windows 7 are the same and in the same order, namely:
Visual Basic For Applications
Microsoft Access 11.0 Object Library
Microsoft DAO 3.6 Object Library
Microsoft ActiveX Data Objects 2.1 Library
Microsoft Office 11.0 Object Library
Microsoft Excel 11.0 Object Library
Any assistance on how to correct the problem without implementing the changes from last month using Windows XP SP3 would be most helpful.