Lookup file
-
Yana
- Posts: 51
- Joined: October 6th, 2016, 6:57 am
Lookup file
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.
You do not have the required permissions to view the files attached to this post.
-
Gregory Martin
- Posts: 1948
- Joined: December 5th, 2011, 11:27 pm
- Location: Washington, DC
Re: Lookup file
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.
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
- Posts: 3
- Joined: January 11th, 2017, 7:19 am
Re: Lookup file
This problem still occurs in the latest beta version of CSPro 7.0 and not in CSPro 6.3
How can we fix this?
How can we fix this?
-
jhgkinds
- Posts: 3
- Joined: January 11th, 2017, 7:19 am
Re: Lookup file
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.
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
- Posts: 1948
- Joined: December 5th, 2011, 11:27 pm
- Location: Washington, DC
Re: Lookup file
Wow, that is great sleuthing! I'm glad that you found a solution to the problem.