VBA Won't Run: Word/Excel 2000 & XP

[tallbarb]

I have MS Office 2000 & XP installed on a PC (Windows 2000 and used for training on both versions of Office). If I try to run the Visual Basic Editor from either Word or Excel, the apps. crash. I tried reinstalling. Still crashes. I have the same environment on other PCs with no problem. Anybody have some suggestions on what might be wrong?

I truly am thankful to have access to a forum like this. What a great resource!!!

 

[Dreamboat]

Hi again, Barb.

Do you have your macro security set to high?
Tools-Macros-Macro security.
Set to medium or low, but not High.

If it still crashes, I'd run Detect and Repair from their respective help menus.

Anne Troy

http://www.TheOfficeExperts.com

Word and Excel Macros
Coming soon: wX

 

[tallbarb]

Nope - I had already checked the security level & made sure it was set to low & it still crashed. I even reinstalled Office XP and removed '97/2000 - and I still can't get VB editor open in either Word or Excel.I can run VB in Access no problem. ARGGGGGGG

 

[Dreamboat]

Try the registry edits I give under Troubleshooting:

Word:

http://www.theofficeexperts.com/word.htm

(step 5)

Excel:

http://www.theofficeexperts.com/excel.htm

(I forget which step, but you'll find it)

Anne Troy

http://www.TheOfficeExperts.com

Word and Excel Macros
Coming soon: wX

 

[KenWright]

Not heard of this particular error, but very often a bloated *.xlb file can result in crashes and even not being able to start excel again. the xlb file is the toolbar customisation file and can be simply deleted as excel will create a new one next time you open it (Beware though, as you will obviously lose any customisations). Not as prevalent in XP but in any otyher version, a *.xlb file of greater than 50K is usually trouble waiting to happen (Based on a quick and dirty poll of MS Newsgroup users.

Reinstalling will not delete/affect these files so it is possible it could be the cause.

Might be worth a shot.

Regards
Ken............

 

[Dreamboat]

Good one, Ken. I ALWAYS forget about the XLB. Do you think I should add it as part of the troubleshooting steps for Excel?

Anne Troy

http://www.TheOfficeExperts.com

Word and Excel Macros
Coming soon: wX

 

[KenWright]

Hi Anne - I usually frequent the MS newsgroups for Excel, and that one is without a doubt one of the most common problems (And solution) that has been listed for some time now. Hopefully it will get less and less as the problems doen't seem to be anywhere near as prevalent in XP, but there is probably a little way to go before everyone else gets to that version ;-)

Regards
Ken..........

 

[Dreamboat]

Cool. Thanks.

Anne Troy

http://www.TheOfficeExperts.com

Word and Excel Macros
Coming soon: wX

 

[SteveBausch]

If you have both versions in one directory, uninstall both.
At this point, defrag the drive two or three times.
Reinstall again, each in it's own directory.

 

[Dreamboat]

I can't agree with Steve. Defrag has everything to do with speed of the applications and, to my knowledge, nothing to do with the operation of them. Cleaning up your hard drive and running scandisk would be more helpful to get rid of the crash. However, Defrag is always a good thing to do on a regular basis too.

As a quickie test, close all apps, hit Start-Run and type %temp% and delete all the files in there.

Also wondering if it ever worked on this PC, or if it's a fresh install?

Anne Troy

http://www.TheOfficeExperts.com

Word and Excel Macros
Coming soon: wX

 

[KenWright]

If you do reinstall, make sure you install in order, with 2000 first and then XP - Obviously as suggested you need to put them in separate directories or you will simply upgrade one.

Following is cribbed straight from a note by Jim Cone in the MS groups:-

MSKB article "OffXP: Running Multiple Versions of Microsoft Office" 290576
says...
"...you must install the earliest version first...because of the way registry
keys, shared programs, file extensions...are managed..."

Also for others interested in the subject...
292491 - Office Automation When Multiple Versions of Office Are Installed

290576 - OffXP: Running Multiple Versions of Microsoft Office

218861 - Off2000: Running Multiple Versions of Microsoft Office

214388 - XL2000: Running Multiple Versions of Microsoft Excel

292584 - OffXP: Setup Overwrites Start Menu Items from Earlier Versions of
office

210391 - Off2000: Setup May Remove Older Components


Regards
Ken.............

 

[tallbarb]

As I mentioned - this is not an unusual situation - having 3 versions of Office installed at the same time and, of course, they were installed in the right order & in different directories, and have been working fine for a year now. The PC in question just recently started having problems (all our PCs are using Win 2000). I haven't tried the registry suggestion yet as the PC in question is in another location & I haven't been back there lately - but I will. And I really appreciate the help....