See http://social.msdn.microsoft.com/Forums ... 4fd9c6b9fc
The registry was corrupted by the Office 2013 uninstall.
Workaround: Never uninstall Microsoft software, even if you don't like it
------------------------------------------
OS: Windows 7, 64bit
Ranorex Version: 4.0.3.22982
ExcelDataConnectorPlugin listed in About
Excel 2013, 64 bit originally installed and used to create the current dataconnectors.
1) ExcelDataConnectors were originally working, connections were created and used
2) Excel 2013 has a different interface than required (need to use Excel 2007, 32 bit).
3) Office 2013 was uninstalled.
4) Office 2007 was installed successfully, updated and patched via windows update.
5) When starting Ranorex and attempt to create a new data connector, navigating to a 2007 excel file results in it not being recognized (worksheet list not displayed, worksheet and range grayed out/disabled).
6) Click OK results in the message "Excel is not installed. ExcelDataConnector requires Excel to be installed"
7) Selecting an existing ExcelDataConnector results in the Name and File Name to be correctly displayed but grayed out/disabled and results in the following error message:
"Unable to cast COM object of type 'Excel.ApplicationClass' to interface type 'Excel._Application'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{xxxxxx,etc}' failed due to the following error: Library not registered. ..., etc. Exception (TYPE_E_LIBNOTREGISTERED).
It appears that the registry is still pointing to 64 bit (no library there now) and not to the 32 bit interface.
I'm totally dead in the water now..
Any help would be greatly appreciated.
Thanks,
Larry
