Can not find library (latest update: 15 Oct 2012)
Performs a cell-by-cell comparison of Excel Worksheets.
Brought to you by:
stevetowner
Menu
▾
▴
#28 Can not find library (latest update: 15 Oct 2012)
When loading excel 2010 in windows 7, get a message: Can not find library.
Code pointer: mdlRegistry, highlight function:
Function RegQueryStringValue(ByVal hKey As Long, ByVal strValueName As String) As String
(this function does not appear in the declarations at the start of the module)
I get the same thing, Windows XP and Excel 2007 even in admin mode.
Can't even see how to remove all traces of this product.
Spreadsheet Compare is a very useful addin. It worked for me very fine the last months or longer. I was very frustrated when an Excel file opened suddenly in the debugging mode. Because my problem is addressed in the support page several times and the solutions offered did not helped I want to contribute a possible solution.
After two days of trial and error I always was told that the MSCOMCTL.OCX is missing. It was not! The cause must have been the installation of a new software (I could not figure out what software, however). I repeatedly registered mscomctl.ocx using the standard regsvr32 C:\WINDOWS\system32\mscomctl.ocx procedure with success. No success with Excel. Thanks to a system backup I discovered that the actual mscomctl.ocx was version 6.00.8862 probably due to the software installation (Japanese language program 2002?). The backup version was 6.01.9834. Again the replacement had no effect.
Heureka: I deregistered with regsvr32 -u C:\WINDOWS\system32\mscomctl.ocx
and registered again regsvr32 C:\WINDOWS\system32\mscomctl.ocx.
After rebooting there was no complain from Excel anymore.
May the versions were not so important but regsver32 -u following by regsver32.
My OS: XP SP3, Office 2007
Thanks. Added this to the help file.
Not seen that before. Are you running Win 7 x64 and do you have Excel x64?
Can you post a screen shot?
Thanks, Steve
Running excel 2010 windows 7 32 bit. Program stops at:
Function RegQueryStringValue(ByVal hKey As Long, ByVal strValueName As String) As String
when loading excel.
See attach snap, do needful,
Thanks a lot Steve, you are rock..
This is a different issue. Please post in a different bug report to avoid confusion.
Thanks, Steve
found solution of my problem,,
The error is usually a wrong reference. In the VB editor, Tools >
References, if you find some marked Missing, unselect those. it get started working..
Agreed. I have seen issues on x64 where the default dll used by Excel is not the correct one. Removing that reference and adding back in pathed to the Win System32 folder fixes the issue.
I got the same error.. running Excel 2007 on Server 2008 R2 64bit
Same issue for me on Win XP SP2 with Excel 2007. A fix would be more then welcome ;)
I really love to start using this addon.
Can you send a screen shot so I can see exactly what line in function is causing the problem. There is a direct reference to 'advapi32.dll' in that code. Can you search and confirm that you can find the file?
Thanks, Steve
Win7 64 bit with Excel 2007 seems to have the same issue.. Screen shot attached.. advapi32.dll is present in System32 folder.
Ok. Chr$ is provided by the 'Visual Basic for Applications' reference, which appears to be the issue. In my Excel, I have a reference to 'C:\Program Files (x86)\Common Files\Microsoft Shared\VBA\VBA7\VBE7.DLL'. Can you check if you have this, and try adding it again.
Thanks, Steve
Note: Previous post screenshot did not include highlighted line.. Line contents: Function RegQueryStringValue(ByVal hKey As Long, ByVal strValueName As String) As String
(attempting proper screenshot attachment again..)
Hi Steve-
It looks like this is the issue for me.. I do not have the C:\Program Files (x86)\Common Files\Microsoft Shared\VBA\VBA7 folder, so obviously the VBE7.DLL is missing as well.
Note: C:\Program Files (x86)\Common Files\Microsoft Shared\VBA\VBA6\VBE6.DLL is present.
I will work on getting VB7 installed.
Update: I am not able to easily locate VB7 source files.. It seems VB7 is part of Office 2010? Any information or guidance you might have would be appreciated.
P.S.- Sorry for my lack of computer literacy.. :-)
P.S.2- System Info..
MS Windows 7 Pro SP1, Ver: 6.1.7601
MS Office Pro Plus 2007, 12.0.6612.1000
Please let me know if any other information would be useful for you.
VB6 should be used in your case. Excel works with whatever version is applicable on the computer, so it should have switched to vb6 instead. At any rate, add VB6 as a reference and see if that works. It may not (or it would have done the change automatically).
Hi Steve-
I tried re-entering the existing (and correct) VB6 reference, but no change. While there, I did see that C:\Windows\SysWOW64\MSCOMCTL.OCX was listed in the references as missing. After removing this reference I appear to be working..
Thank you!
Glad that fixed it for you.
Steve
Still experiencing same problem as above. Running XP SP3 with Excel 2007, and VB6. I've attached a screenshot. References is grayed out under tools, so I can't check for missing items. Any ideas? I would really love to be able to use this.
Thanks!
You cannot go to references because the code is still running. You need to stop the code running (click on the stop square, or through menu) and then go to references.
Screenshot009.jpg is what I receive on opening Excel 2007 with 2 spreadsheets selected. The following screenshots are what I receive on initially opening Excel 2007: