Lookup file

[Yana]

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.

[Gregory Martin]

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.

[jhgkinds]

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

[jhgkinds]

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.

[Gregory Martin]

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