An error occurred initialising the vba libraries (1004)

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?
instemAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

instemAuthor Commented:
At this point I'm prepared to try anything.  Any suggestions, gratefully accepted!!
0
instemAuthor Commented:
Increasing Points
0
Joanne M. OrzechManager, Document Services CenterCommented:
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
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

instemAuthor Commented:
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
Joanne M. OrzechManager, Document Services CenterCommented:
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
instemAuthor Commented:
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
Joanne M. OrzechManager, Document Services CenterCommented:
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
instemAuthor Commented:
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
Joanne M. OrzechManager, Document Services CenterCommented:
Excellent then.  Thanks for the update -- good luck!  Will await word.

Joanne


0
instemAuthor Commented:
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
instemAuthor Commented:
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
instemAuthor Commented:
Oh and if she logs onto my machine everything works fine.
0
Joanne M. OrzechManager, Document Services CenterCommented:
... my my my.... a myriad of odd issues....
0
instemAuthor Commented:
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
Joanne M. OrzechManager, Document Services CenterCommented:
0
instemAuthor Commented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Joanne M. OrzechManager, Document Services CenterCommented:
Thanks so much. I'm glad everything is working for you now!

Joanne Orzech
MS Word MVP
EE Zone Advisor
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Applications

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.