Solved

An error occurred initialising the vba libraries (1004)

Posted on 2009-06-29
17
2,953 Views
Last Modified: 2012-05-07
I have one remote user who is experiencing this issue.  She's running Windows XP SP3, Office 2003 and is fully patched up and it's affecting all office products, not just excel.  As all of the documents she works on contain macros, this is causing her severe difficulty.  I have researched for 3 days not but cannot find a solution.  I have uninstalled and re-installed the VBA tools (uninstalling and reinstalling Access in the process). I have tried a repair, I have checked that her oleaut32.dll is the same as mine.  I am thinking that it may be a profile related issue but I don't know.  Does anyone have any other suggestions for me?
0
Comment
Question by:instem
  • 10
  • 7
17 Comments
 

Author Comment

by:instem
ID: 24761522
At this point I'm prepared to try anything.  Any suggestions, gratefully accepted!!
0
 

Author Comment

by:instem
ID: 24784448
Increasing Points
0
 
LVL 37

Expert Comment

by:Joanne M. Orzech
ID: 24818088
Sorry you've had no response.... here's an other post that had the same problem.
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Q_21423010.html
0
 

Author Comment

by:instem
ID: 24818569
Hi JOrsech,

Thanks for replying, I did read through that post before I posted mine but I'll carefully go through everything again (I admit there's probably some stuff I didn't try as it didn't seem to fit but you never know) and post asap.  Don't think my user works a Friday, and definitely not Monday, so it may be Tuesday next week, but I'll try to get her to put her machine online tomorrow anyway, and get back to you.  Thanks again for responding.
0
 
LVL 37

Expert Comment

by:Joanne M. Orzech
ID: 24822772
Thanks for your response instem.  It seems that much of my research pointed to the fact that VB was set to run on first use or cancelled during installation or some other installation problem.  However, you stated that you've reinstalled several times, so that doesn't appear to be your problem.

I'm wondering if the user can try this from a different computer to see if it gives the same error?  That may narrow things down a bit for you as far as troubleshooting goes.

Keep me posted :)

0
 

Author Comment

by:instem
ID: 24847747
OK.  Finally got onto the users machine and followed some of the registry hacks but to no avail.  I then decided to look at the profile angle again so right clicked and did a Run As and opened Excel as myself and attempted to open the Visual Basic Editor which opened no problem.  Could get to the Add-Ins and everything.  Tried it with a different Run As account and still fine.  Opened Excel normally as her and the 1004 error initializing VBA libraries came back (note this also applies to Macros and VBA activity when she opens Word as well).  So it looks as though it's profile related.  Don't know whether attempting a complete uninstall / reinstall would do any good but I'm loath to blow away her profile and create a new one as she has so many customisations.  What would be your advice?
0
 
LVL 37

Assisted Solution

by:Joanne M. Orzech
Joanne M. Orzech earned 200 total points
ID: 24849990
I highly doubt if a reinstall would change anything since everything works fine under other login's....
Although you could try this:
http://support.microsoft.com/?kbid=811151
0
 

Author Comment

by:instem
ID: 24850251
I thought that might be the case, I was going to copy the profile if necessary.  Hopefully it will be OK to wait on the result of this for a bit because I'm going to wait until the user comes into our office which will be 2 weeks tomorrow and complete this whilst she's connected to the network.  I'll post an update as soon as I'm done.  Thanks for your help so far.
0
What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

 
LVL 37

Expert Comment

by:Joanne M. Orzech
ID: 24853638
Excellent then.  Thanks for the update -- good luck!  Will await word.

Joanne


0
 

Author Comment

by:instem
ID: 24969150
OK.  D-Day.  I finally managed to rename her existing docs and settings folder and have removed her as an admin.  Logged on as local administrator and checked that I could open macro enabled docs and spreadsheets which I could.  Exported the HKCU\software\microsoft\office registry key.  Logged back in using her domain account which created the new docs and settings folders and applied the registry key to prevent the "This software has not been installed for the current user" error.  Checked that macro security was set to medium and attempted to open the same docs and spreadsheets that I opened as a local admin.  VBA error came back immediately.  I have not copied over anything from her old profile. Opening these documents is the only thing I've done to the profile apart from importing the  registry key.  Help please.
0
 

Author Comment

by:instem
ID: 24970511
A further update.  When I log back on as the user it does all the setting up browser settings etc. but when I open word for what should be the first time it does not go through the setting up ritual.  Just goes straight to the Software not set up for this user error followed by the vba error.  I created a new domain user called kimtemp which was just in the domain users group and logged on with that.  Word / Excel worked fine with this account just like all of the others I've tried including a domain user who's profile I had removed and then logged back in again as with this problem user account. I tried removing the user again and running ccleaner but it still happened.  I am currently uninstalling office completely, will then remove the user and then run ccleaner again to see if this resolves the issue.
0
 

Author Comment

by:instem
ID: 24970520
Oh and if she logs onto my machine everything works fine.
0
 
LVL 37

Expert Comment

by:Joanne M. Orzech
ID: 24970588
... my my my.... a myriad of odd issues....
0
 

Author Comment

by:instem
ID: 24978367
OK.  A further update.  I uninstalled Office 2003, then blew away her account for a 6th time.  I then ran the reg cleaner again.  Logged back in as her (after giving her back admin privileges to the machine).  I then performed a full install of office 2003 (whilst logged in as her) using a batch and MSTfile so that there's no need to input keys manually etc.  This completed successfully.  HOWEVER, when I looked at what had been installed under Start, Programs, only the MS Tools, Infopath and Publisher were installed.  The install I used checks to see what's missing and installs the missing bits so even though she had only just logged in, something is cached somewhere because the installation believed that Word, Excel, Powerpoint and Access were already installed.  This may somehow (although I'm at a loss) explain that why, even though I was installing and uninstalling the VBA and Access, it never resolved the issue.  We are continuing on but any other suggestions would be appreciated.
0
 
LVL 37

Assisted Solution

by:Joanne M. Orzech
Joanne M. Orzech earned 200 total points
ID: 24979798
0
 

Accepted Solution

by:
instem earned 0 total points
ID: 24980068
OK.  It's now working.  We uninstalled some of our software that utilises Word as part of it's reporting  and then gone through the previous user and office removal and re-install and it is now working.  Somehow it ruined the Macro setup.  Thanks for your help though
0
 
LVL 37

Expert Comment

by:Joanne M. Orzech
ID: 25013017
Thanks so much. I'm glad everything is working for you now!

Joanne Orzech
MS Word MVP
EE Zone Advisor
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
Using Word 2013, I was experiencing some incredible lag when typing.  Here's what worked for me....
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

706 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

18 Experts available now in Live!

Get 1:1 Help Now