Excel error

J

John

Hi all,

I am getting 2 messages when I open Excel.

1. When I open Excel I get "Cannot use object linking and
embedding". I click OK.

2. I then try to open a file containing macros. When I
click on "enable macros" a message comes up saying "An
error occurred initializing the VBA libraries(14)". The
file then closes.

Can anyone help please!!!

Thanks
John
 
R

Rob Bovey

John said:
I am getting 2 messages when I open Excel.

1. When I open Excel I get "Cannot use object linking and
embedding". I click OK.

2. I then try to open a file containing macros. When I
click on "enable macros" a message comes up saying "An
error occurred initializing the VBA libraries(14)". The
file then closes.

Hi John,

You didn't indicate what version of Office you're running, so I've
copied a Knowledge Base article below that describes how to solve this
problem in Office 2000.

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *


PSS ID Number: Q224315
Article last modified on 06-20-2001

=============================================
---------------------------------------------
The information in this article applies to:

- Microsoft Excel 2000
- Microsoft Word 2000
- Microsoft PowerPoint 2000
- Microsoft Access 2000
-----------------------------------------------

SYMPTOMS
========

When you attempt to start the Visual Basic Editor in Microsoft Excel 2000,
the following error message appears:

An error occurred initializing the VBA libraries (1004).

When you attempt to start the Visual Basic Editor in Microsoft Word 2000,
the following error message appears:

The Visual Basic Environment could not be initialized.

When you attempt to start the Visual Basic Editor in Microsoft PowerPoint
2000, the following error message appears:

The DLL function "LoadTypeLibEx" was not found.

When you attempt to start the Visual Basic Editor in Microsoft Access 2000,
the following error message appears:

The file 'OLEAUT32.DLL' is out of date. This program requires a newer
version.

followed by:

Microsoft Access is unable to load the Visual Basic for Applications
dynamic-link library (DLL) Vbe6.
Rerun the Microsoft Access Setup Program.

CAUSE
=====

This problem occurs if an outdated version of Oleaut32.dll is installed on
your computer.

RESOLUTION
==========

If the application does not close after you receive the error message,
follow these steps to resolve the problem:

1. Click Detect and Repair on the Help menu.

2. Click Start in the Detect and Repair dialog box.

The Office Setup program replaces the outdated copy of Oleaut32.dll.

If the application closes after you receive the error message, use these
steps to resolve the problem:

1. Click Start, point to Settings, and click Control Panel.

2. Double-click Add/Remove Programs.

3. Double-click Office 2000.

4. Click Repair Office.

5. Click to select Reinstall Office and click Finish.

NOTE: Due to the outdated version of Oleaut32.dll, the error messages may
appear during the reinstallation. Click Ignore in each error message dialog
box to continue.

REFERENCES
==========

For additional information about Office errors that can occur with an
outdated version of Oleaut32.dll, please see the following article in the
Microsoft Knowledge Base:

Q217440 OFF2000: Errors Starting Programs with Outdated Oleaut32.dll
 
Joined
Jan 16, 2007
Messages
1
Reaction score
0
I have the same problem

This is the old article but I hope that someone can steel help me, first I have message "Cannot use object linking and embeding" after that have "An error occurred initalizing the VBA libreries (14) in a case when I try to use EXCEL files.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top