Compile Error in Hidden Module

[saidanddone]

I recieve a "Compile Error in Hidden Module" error message when Excel is
started. I have followed the advice given in KB 307410. I have gone as far as
uninstalling Adobe Acrobat Reader 6.0 and Installed Adobe Acrobat Reader 7.0.

I have also Upgradede Office to 2003 Pro.

This issue occurred after doing a System Restore. Everything I did above was
done after the restore was completed. I need another way to fix this. Do I
uninstall Adobe Acrobat Reader again and then go through the registry to
remove ALL instances of of Adobe I find. I have searched everywhere and have
not been able to find a solution. Can anyone help ??

 

[frodo1baggins]

I wish someone would answer this - I've done all the same and still have the
error on launch and close.

 

[utah432]

I have the same issue. I have done everything possible to fix this except a
total reinstall of the computer.
This is getting frustrating.
Does anyone have an answer?

 

[Rob Bovey]

This error is being caused by a malfunctioning Excel program that is being
loaded when Excel starts up. There are two places where program workbooks
could potentially be running from. Here's how to find them and get rid of
them:

1) Select Tools/Add-ins from the Excel menu.

2) In the Add-Ins dialog, uncheck every add-in that has a checkmark beside
it. Make note of the names of the add-ins you uncheck, then click OK.

3) Close Excel and use Windows Explorer to navigate to your XLStart
directory. If you installed Office to its default location, this will be:

C:\Program Files\Microsoft Office\Office(x)\XLStart

where (x) will be absent for Office 2000 or the number 10 or 11 for Office
XP or Office 2003, respectively.

If you're running Windows 2000 or XP, there's an additional start directory
you need to check located at:

C:\Documents and Settings\<username>\Application
Data\Microsoft\Excel\XLSTART

Where <username> is the username you're logged in as.

4) If there are any files in the XLStart directory, move them to another
location temporarily (don't rename them and leave them there, it won't
work).

Once you've done all this, restart Excel and the problem should be gone. To
determine exactly which program file was causing the problem, add them back
one at a time, restarting Excel each time until you get the error again.
When that occurs, whichever one you added last is the culprit.

--
Rob Bovey, Excel MVP
Application Professionals
http://www.appspro.com/

* Take your Excel development skills to the next level.
* Professional Excel Development
http://www.appspro.com/Books/Books.htm

 

[utah432]

I have already did all of this to no avail.
Any other suggestions?

Thanks

 

[Rob Bovey]

I have already did all of this to no avail.
Any other suggestions?

The only thing that can be causing this problem is an Excel application
that is being loaded automatically on startup. The list below covers every
possible scenario that could cause this to happen. I'd go back through it
and make sure you follow the entire list exactly as specified.

To verify that you have removed everything correctly, do the following:

1) Open the Visual Basic Editor (VBE) by choosing Tools > Macro > Visual
Basic Editor from the Excel menu.

2) Locate the Project window, which should be a small window located near
the upper left side of the VBE window (press Ctrl+R to activate it if you
don't see it).

3) If you have successfully removed everything there should be only one
entry in the Project window. That entry will look similar to the following:

+ VBAProject (Book1)
- Microsoft Excel Objects
- Sheet1 (Sheet1)
- Sheet2 (Sheet2)
- etc......

If there are any other entries in the Project window at the same level as
the VBAProject (Book1) entry then you still have programs opening on
startup.

--
Rob Bovey, Excel MVP
Application Professionals
http://www.appspro.com/

* Take your Excel development skills to the next level.
* Professional Excel Development
http://www.appspro.com/Books/Books.htm