asked on

My VBAJET32.DLL is not working

I have a government program called the knowledge center. One of the function of the program is to export data to EXCEL. The error when exporting is:

The Jet VBA file (VBAJET.dll for 16-bit versions of VBAJET32 for 32-bit versions) failed
to initialize when called. Try reinstalling the application that returned the error. (3447)

The environment is:

Windows NT 4
MS Office 2000
IE 5.5
with current patches

I reloaded office
I reloaded IE 5.5 and redid the patches
I reloaded SP6a for NT
The knowledge center client software has been reloaded.
The file in question exists and has been replaced individually.

The problem only occurs on one version of computer. There are two computer in the area.
One is a Compaq and one is a generic with standard HCL acceptable parts.

The program exports on the Compaq but fails on the generic. I don't want to reimage these machines.

What does VBA JET do?
Where is is found?
Is this a registry error?
Is the problem in Win NT or Office or IE?

SysExpert

1) Get the service pack for msoffice

2) Make sure that you installed the VBA stuff for excel. It may not be part of a standard install

3) Check the MS site for the error message you received !

I hope this helps !

lyonst

Hi,

This should answer your problem..

http://support.microsoft.com/support/kb/articles/Q196/0/57.ASP

Applications like Visual Basic 6.0 and Visual C++ 6.0 install new versions of the DAO and Jet files on your development computer. Any version of VBAJet32.dll 6.0.1.8132 or later is now dependent on the file Expsrv.dll. The error occurs with your original setup program because it does not include Expsrv.dll in the dependency information.
RESOLUTION
To resolve the error, do one of the following:
Manually add Expsrv.dll to your file list for your existing setup program.

Re-create a new setup program from scratch that includes this new dependency.......

Cheers,

T.

ASKER CERTIFIED SOLUTION

lyonst

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Asta Cu

Please update the experts here who have so willingly stepped in to help you, since much time has passed since your last comments, and Email notifications may not have been generated to the participating experts here due to some problems at that time. If you've been helped, accept the respective comment by that expert to grade and close it.

To see all your Open and Locked questions, click your member profile and View Question history to update/close them as well.

Somewhat off-topic, but important.

****************************** ALERT********************************
WindowsUpdate - Critical Update alert March 28, 2002 from Microsoft
http://www.microsoft.com/technet/treeview/default.asp?url=/technet/security/bulletin/ms02-015.asp
Synopsis:
Microsoft Security Bulletin MS02-015
28 March 2002 Cumulative Patch for Internet Explorer
Originally posted: March 28, 2002
Summary
Who should read this bulletin: Customers using Microsoft® Internet Explorer
Impact of vulnerability: Two vulnerabilities, the most serious of which would allow script to run in the Local Computer Zone.
Maximum Severity Rating: Critical
Recommendation: Consumers using the affected version of IE should install the patch immediately.
Affected Software:
Microsoft Internet Explorer 5.01
Microsoft Internet Explorer 5.5
Microsoft Internet Explorer 6.0

Thought you'd appreciate knowing this.
":0)
Asta

Rhb

ASKER

We later found that the version of Office that was loaded on the computers in question had a number of problems. Several files had not loaded with the installation. We ended up removing and re-installing the Office product from a different version of the product. Although the option we used was to reload the whole product I did test the alternative suggestion about replacing one file and had some success. To many files were missing.

In general IVONST was the most correct. I still wish that I could give devided credit.

i apologize for not resolving this cas earlier.

Thanks for the help.