Solved

My VBAJET32.DLL is not working

Posted on 2001-08-11
5
216 Views
Last Modified: 2013-12-28
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?
0
Comment
Question by:Rhb
5 Comments
 
LVL 63

Expert Comment

by:SysExpert
Comment Utility
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 !
0
 
LVL 15

Expert Comment

by:lyonst
Comment Utility
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.
0
 
LVL 15

Accepted Solution

by:
lyonst earned 200 total points
Comment Utility
0
 
LVL 27

Expert Comment

by:Asta Cu
Comment Utility
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
0
 

Author Comment

by:Rhb
Comment Utility
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.
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Windows Mobile Barcode Scanning These days almost every product has a barcode in some way... amongst there are 1D barcodes en 2D barcodes.. From http://www.barcodeman.com/faq/2d.php I found some handy definitions and insights. 1D barcodes …
A few months ago I had an issue with LaserJet 1020 printer which was installed to XP and Windows 7.  It was installed to XP and working, but when I tried to connect from a Windows 7 PC, it would attempt connection and then fail.  Sometimes the Spool…
In this video, we discuss why the need for additional vertical screen space has become more important in recent years, namely, due to the transition in the marketplace of 4x3 computer screens to 16x9 and 16x10 screens (so-called widescreen format). …
The Task Scheduler is a powerful tool that is built into Windows. It allows you to schedule tasks (actions) on a recurring basis, such as hourly, daily, weekly, monthly, at log on, at startup, on idle, etc. This video Micro Tutorial is a brief intro…

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now