compiler error messages in Word and Excel

[Jay Mark]

I have been using Word and Excel for years with no
problems. Recently I bought a new machine (I'm running XP
home SP2) and whenever I start Word or Excel I get VB
compiler error messages. (Typical is COMPILE ERROR IN
HIDDEN MODULE: AUTOEXEC) I have no VB experience and this
has never happened before. I noticed a similar question
in an earlier post from someone else but because of my
ignorance of VB I could not figure out how to apply the
responses to my problem.

If anyone can help I would be most grateful.

Thanks,

Jay

 

[Howard Kaikow]

If you copied templates from your older systems, then the templates likely
contain references to libraries that do not exist on the new system.

 

[Jay Mark]

Thanks, Howard. I'll check out your site.

Jay

-----Original Message-----
If you copied templates from your older systems, then the templates likely
contain references to libraries that do not exist on the new system.

--
http://www.standards.com/; See Howard Kaikow's web site.



.

 

[Jay Mark]

Hi Howard,

Just wanted to say that after looking at your site and
doing some thinking and experimenting, I found that there
were PDF .DOT files in both the STARTUP and XLSSTART
folders. I found that just deleting those files didn't
solve the problems, so I just renamed the STARTUP and
XLSSTART files so that they're not there anymore, and
everything seems to be fine. I'm assuming that if I do
something in the future that requires those files they
will be recreated.

Thanks again,

Jay

 

[Howard Kaikow]

I doubt that will solve the problem.
It is almost never correct to brute force delete files/directories that are
part of installed software.
At some point Acrobat may recreate those files, not to mention there are now
incorrect entries in the registry referring to those files.
In addition, as I recall, it is necessary to uninstall, then re-install,
Acrobat, under some circumstances AFTER installing a new version of Office.

To fix your problem, you need to examine the templates you moved to the new
system to see what libraries are referenced.
But, I would first do the following:
1. Uninstall Acrobat.
2. Uninstall, then re-install Office.
3. Re-install Acrobat.

Then WHILE holding the SHIFT key, start Word.
Once Word starts:

a. Open the Visual Basic Editor and see what is referenced by the Normal
template by looking at the Tools | References menu.
If anything is listed as MISSING, you have to fix that problem.
b. If the template contains any Auto* macros, see what they do,

b. See what global templates are listed. Exit from Word and OPEN each
template separately, while holding the SHIFT key. See what references each
template uses. If the template contains Auto* macros, see what they do,