error message on start and close

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

splot! - 20 Feb 2008 13:34 GMT

Hello, I'd be grateful if anyone has any ideas on the following error
messages:

On starting Excel (2000 v9.0.6926 SP-3) I get the message: Compile
error in hidden module: mdlInitialize
On closing Excel I get: Compile error in hidden module:
modDataHandling

These messages did not appear last week but have appeared since I
first started Excel this week. I tried restoring to the last system
checkpoint but the system said it couldn't as there had been no
changes. I also uninstalled ASAP utilities in case that was causing
the problem. Neother of these made any difference.

Help tells me that the messages mean a module can't be compiled
because it is hidden and that I should unhide it in order that it may
be compiled. Assuming you agree that this is the correct solution
please could you suggest how I should do this?

TIA

Chris

Reply to this Message

Dave Peterson - 20 Feb 2008 15:20 GMT

It's not just a problem because the module is hidden. The problem is that the
code inside the module has an error in it.

The hidden portion just means that you have to know the password to open that
project so that you can try to fix the real problem.

But I bet you didn't develop this project--else you'd recognize those module
names.

If you want to find the culprit (to uninstall or yell at the developer), you can
do some detective work to find out what workbook/addin owns the code that's
causing the trouble.

Chip Pearson has some notes on how to diagnose startup errors:
http://www.cpearson.com/excel/StartupErrors.aspx

And Jan Karel Pieterse has more notes:
http://www.jkp-ads.com/Articles/StartupProblems.asp

> Hello, I'd be grateful if anyone has any ideas on the following error
> messages:
[quoted text clipped - 18 lines]
>
> Chris

Signature

Dave Peterson

Reply to this Message

splot! - 20 Feb 2008 16:07 GMT

ok thanks I'll have a rummage with those. No one here has written any
projects so they must be pre-existing ones assiociated with something
I already have installed. I shall be interested to see what I
discover :-)

Regards

Chris

Reply to this Message

splot! - 20 Feb 2008 16:54 GMT

I started exploring based on the cpearson site. Although I didn't
immediately discover anything it made me think about Addins. So I
unchecked all addins under tools>addins and then, after re-starting
Excel, I re-checked them one by one, closing and re-strating Excel
after adding each one.

When I first unchecked them all, Excel decided it needed to install
something from the Outlook 2002 installation disk. I cancelled this
and it came back a couple of times but hasn't reappeared since then.
Also when I re-checked the Small Business FInancial Manager there were
some messages about not being able to access a module. However,
having looked at the window it offered me, and closed it, these
messages have not returned. All my original addins are there still
and Excel is opening and closing without complaint.

A bit inconclusive but at least 'problem solved', it appears. Thanks
for the pointers.

Regards

Chris

Reply to this Message