Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

WORD / Excel

Status
Not open for further replies.

akirkhome

MIS
Apr 22, 2002
9
GB
When ever Word or Excel is opened and error message "Microsoft Visual Basic" "code execution has been interrupted" the the options continue or end are available.

Anyone have any ideas how to fix this?
 
Something like this is usually an indication of a macro that does not work properly. That could mean a virus as well. To check, I'd first rename normal.dot. Make sure there are not more than one instance of normal.dot on ur system.

this doen't take care of the Excel problem. for that, try to see if there is anything in the Excel startup folder. hard for me say where it would be located since I don't the OS ur using.
 
Usually this indicates a macro virus where the code is failing because the macro was originally written for a different version of MS Office.

In addition to the advice above, get a virus checker to scan the PC. For a private PC you can get a free AV checker at
If you already have an AV program ensure the signature file is up todate.

Ken
 
I disagree with cheerio to the extent that I would remove the word VIRUS from his first sentence and because, since 97, most macros will run in the 3 most recent versions. Just because a macro fails does not make it a virus.

There are many programs these days that install themselves into the Office Suite and you're not warned:


...as well as others. Anne Troy
 
Anne

You are probably right that it is an add-in or AV problem.

However, I disagree with your comment that most macros will run across most versions. That will be true for someone as clever as you because you will know how to avoid the problems. However, try running VBA code created in Office 2000 that uses the Enum statement in an older version. What about the endless problems caused by code written for DAO being misunderstood as ADO?

The fact is that many less knowledgeable people do write code that does not run properly across Office versions. That includes sloppy commercial code and some poorly written viruses.

If the problem is a virus then it needs to be dealt with before harm is done. Once you know it is not a virus you can then look at installed add-ins.
 
I must agree with Anne that it is not a virus. Macros that cause errors stop running because of the errors, and a Macro Virus that doesn't run can't spread, meaning it is no longer a Virus.

And it is true that _most_ macros run across all three recient versions. There are some, however that do not work properly on different versions, either direction (older macros that don't run on newer versions of Office as well as newer macros that won't run on older versions of Office.)

I'd try removing the addins before I'd panic about a virus. When both Excel and Word are having a problem, this is often caused when a program is uninstalled and the program didn't remove it's Office addins. Check out the startup folders.

Steve
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top