During upgrading windows and Microsoft Office, sometimes the Office directory
moves to Office10, Office11, or office12 (under c:\Project Files\Microsoft
Office). I seen cases where this process was not done properly.

The solution is simple. Go to VBA menu Tools - Reference and select
Microsoft Excel XX.X Object Library. Then go to Browse and find the library.
Select the name and then press OK.

for some reason the name is selected properly but Excel doesn't recognize
the selection. Many people have the problem with the REF Edit object on
userforms.


Office program name Type library name
File name
Microsoft Access 2002 Microsoft Access 10.0 Object Library
MSACC.OLB
Microsoft Excel 2002 Microsoft Excel 10.0 Object Library
EXCEL.EXE
Microsoft FrontPage® 2002
Microsoft FrontPage 5.0 Web Object
Reference Library

FRONTPG.EXE
Microsoft Office XP Microsoft Office 10.0 Object Library
MSO.DLL
Microsoft Outlook® 2002 Microsoft Outlook 10.0 Object Library
MSOUTL.OLB
Microsoft PowerPoint® 2002
Microsoft PowerPoint 10.0 Object
Library MSPPT.OLB
Microsoft Word 2002 Microsoft Word 10.0 Object Library
MSWORD.OLB


"Leon Galushko" wrote:

Hi,



after some extensions to my VBA Excel PROJECTS OPTIONS by some extra

the essential option



Visual Basic runtime objects and procedures



has been missing;



Visual Basic objects and procedures is still there, but it puts my vba -
macro out of work.

I made some internet search and assumed that is about some DLL -
Libraries links, which is now failing.

I gone so far as to reinstall my Windows and Microsoft Office, but it
didn't help.

Any ideas how it can be reinstated?

Thanks