CSPro Users Forum

Hey gentlemen , when I have trying to add lookup file from excel to cspro as usual I can't do as before. The following error is occurred. So please give me your usual wise advise thanks very much.

What version of Excel do you have on your computer?

You might try installing the CSPro 7.0 beta: http://www.csprousers.org/beta/

The Excel to CSpro tool has been completely rewritten, so you can check if the new tool works for you.

This problem still occurs in the latest beta version of CSPro 7.0 and not in CSPro 6.3
How can we fix this?

When you proceed in CSPro 6.3 the same error occurs, but after a long search I found the solution.
It's a little bit tricky, because you have to open the registry with regedit.
Find:
HKEY_CLASSES_ROOT
WOW6432Node
TypeLib
{00020813-0000-0000-0000-C000-000000000046}
and remove here all empty versions.
I have installed Microsoft Office 2013 which corresponds with 1.8,
so only leave 1.8 and remove 1.9, because 1.8 has a key PrimaryInteropAssemblyName wich points to your installed MS EXCEL version = 15.0.0.0
If there is a 1.9 with another key then the system crashes when your CSPro invokes the excel com object, which yields the error message.

Wow, that is great sleuthing! I'm glad that you found a solution to the problem.