Applications Extensibilty 5.3 Problem after upgrade

[todd.huttenstine]

My company switched my pc from Windows 2000 to Windows XP Pro and
installed a new version of Office. My old version was 2000 and now I
have 2003 or XP(Im not sure since it doesnt say). The version number
of office Excel is (11.8146.8132) SP2.

After this change I have been getting the error on this one project
that used to ALWAYS work with my old pc and version of Excel. The
error I get is:
"Compile error: Cant find project or library"

Then when I click ok, it highlights the following code in my project:
"Function CompTypeToName(vbcomp As VBComponent) As String"

This code came from Chip Pearson and the library needed is "Microsoft
Visual Basic for Applications Extensibilty 5.3"

Problem is - I have this library highlighted and still get the error.

I have had similar problems in other projects that use different
libraries, but have managed to fix them by removing the reference to
the "problem library" and then putting it back. After that my project
would always work. Im not sure if this is a glitch or installation
issue. Anyway that worked on my other projects but will NOT work to
fix this project that uses "Microsoft Visual Basic for Applications
Extensibilty 5.3".

I even removed the reference to "Microsoft Visual Basic for
Applications Extensibilty 5.3" saved the project, exited Excel,
restarted Excel, opened my project added it back, and still got the
same error.

Then I tried to download the example book from Chip Pearson's website,
I even got the error with that workbook. I verified that "Microsoft
Visual Basic for Applications Extensibilty 5.3" was checked.

I also checked in my "C:\Program Files\Common Files\Microsoft Shared
\VBA\VBA6" program directory and browsed for the "VBE6EXT.OLB" and set
the reference that way. That still didnt work.

Just in case this is important, the files located in this directory
are:
apc64.dll (version 6.4.98.91)
VBACV10.DLL (version 2.0.0.7411)
VBACV10D.DLL (version 2.0.0.7411)
VBACV20.DLL (version 2.0.0.6712)
VBE6.DLL (version 6.4.99.72)
VBE6EXT.OLB (version 6.0.99.71)

I have even restarted and still get the same error.

I just dont know why I cant get this to work. Could it be a policy of
some sort? Any suggestions?



Thanks
Todd

 

[Chip Pearson]

The first thing I would try is to re-register Excel's libraries with
Windows, essentially setting Excel back to "factory defaults". Close Excel,
and then go to the Windows Start menu, choose Run, and enter

Excel.exe /regserver

You may have to provide the complete path to Excel.exe. E.g.,

"C:\Program Files\Microsoft Office\Office\Excel.exe" /regserver

This will cause Excel to start, reregister all of its components, then quit.
After that, try starting Excel normally. If you have multiple versions of
Excel on the machine, do a /regserver on each version, from earliest to
latest.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)