Unable to connect to QuickBooks
The following are the possible reasons why you are getting that error message:
To resolve it, you will need to make sure that Microsoft Office is compatible with the version of QuickBooks that is open- make sure that only one version is open when using Office tie-in features.
It is possible that you either use an incompatible version of Microsoft Office (64 bit) or the installation file for QuickBooks is corrupted. Try to use the 32-bit version of MS Office and try to install QuickBooks again.
You actually have two different problems.
One is, if you are using Excel 2010 64-bit product the QuickBooks product does not support in the 64-bit program. So if you still want to use QuickBooks you have to find out the supported version for 64-bit.
Your other problem is your ActiveX component can’t create an object which you can solve with the following instructions:
1. Click to Start button, then go to Run.
2. To find DAO file, Type regsvr32.
3. Use the quotation mark to enclose the DAO file’s path. Such as: regsvr32 "C:Program FilesCommon FilesMicrosoft SharedDAODAO360.DLL"