Solved

My VBAJET32.DLL is not working

Posted on 2001-08-11
5
226 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

Question has a verified solution.

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

Ever visit a website where you spotted a really cool looking Font, yet couldn't figure out which font family it belonged to, or how to get a copy of it for your own use? This article explains the process of doing exactly that, as well as showing how…
Sometimes clients can lose connectivity with the Lotus Notes Domino Server, but there's not always an obvious answer as to why it happens.   Read this article to follow one of the first experiences I had with Lotus Notes on a client's machine, my…
Windows 8 comes with a dramatically different user interface known as Metro. Notably missing from the new interface is a Start button and Start Menu. Many users do not like it, much preferring the interface of earlier versions — Windows 7, Windows X…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

696 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