Solved

My VBAJET32.DLL is not working

Posted on 2001-08-11
5
220 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
ID: 6375631
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
ID: 6379657
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
ID: 6379674
0
 
LVL 27

Expert Comment

by:Asta Cu
ID: 6907397
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
ID: 6910048
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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Join Greg Farro and Ethan Banks from Packet Pushers (http://packetpushers.net/podcast/podcasts/pq-show-93-smart-network-monitoring-paessler-sponsored/) and Greg Ross from Paessler (https://www.paessler.com/prtg) for a discussion about smart network …
A project that enables an administrator to perform actions within a user session context not just at the time of login but any time later on day(s) or week(s) later.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
This Micro Tutorial will give you a basic overview of Windows DVD Burner through its features and interface. This will be demonstrated using Windows 7 operating system.

733 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