Fix start-up error: "Compile Error in Hidden Module: Procedures"

[Guest]

Whenever I start Excel, I get the above error message. I can click OK and I
get in, but it appears again upon exiting. Upon startup I also get a "can't
find file" message looking for file: "C:\Program Files\Microsoft
Office\Office11\Library\Analysis\Funcres.xla" This all started when I tried
unsuccessfully to load add-ins. I've uninstalled and reinstalled MS Office
but these errors continue.

 

[Bill Manville]

The file you mention is part of the Analysis toolpak.
Either remove the analysis toolpak from your selected add-ins and/or
VBE references, or ensure that the analysis toolpak is installed.

The compile error will be in an add-in that you have installed.
Try de-installing each until you find the culprit

Bill Manville
MVP - Microsoft Excel, Oxford, England

 

[Guest]

Thank you for your response. I think this is a bigger problem, as I recently
installed a third-party add-in called "XLSTAT-Pro". Everything in Excel
under Tools/Add-ins is unchecked.

I have attempted to uninstall the third-party software by going to the
"Add/Remove Programs" option from the Control Panel, but the program is not
listed. I can see the program under C:\Program
Files\Addinsoft\XLSTAT\XLSTAT-Pro. In that folder there is an "Uninstall"
icon, but it doesn't work. It just opens the Excel program and returns the
same error message. When Excel opens, the worksheet title shows up as
"AutoExec" and the title in the blue title bar at the top is: "Microsoft
Excel - AutoExec.bas"

I've tried unsinstalling and reinstalling the entire Office program but it
did not resolve the problem. I may just have to try to do a system restore
to a date prior to loading this add-in. That will be my last resort. If
you could give me any further guidance, I would be very appreciative. Thank
you.

Sandy

 

[Bill Manville]

XLSTAT may have installed a file in your XLSTART directory (there are a
number of locations for such a directory, the contents of which are
automatically opened when you run Excel normally).

The most likely is in C:\Program Files\Microsoft Office\Office<nn>

Bill Manville
MVP - Microsoft Excel, Oxford, England

 

[jksmurf]

Compile error in hidden module: Procedures .... FIXED

I was going crazy... so this FIX is for anyone else going crazy.

My error message on Excel open and close, similar to all the others, but there was no MS fix as for the others. Error was:

"Compile error in hidden module: Procedures"

A Google search notes it is in an XLA error in a Statistics program called XLSTAT, which I had on my machine for Trial, but uninstalled, or so I thought.

A forum search on this forum "compile error in hidden module" threw up 3 pages of similar problems with solutions varying from those proffered by Microsoft to those proffered by other add-in vendors. These included unchecking the Add-ins one by one and removing .XLA files from a specific add-in directory.

None of these worked, but many said look in

C:\Program Files\Microsoft Office\Office10\XLStart and remove all the files. Mine was empty.

I also looked looked in

C:\Program Files\Microsoft Office\Office10\Addins and remove the offending file. Mine had NO xla files in it.

I even searched for and deleted all the registry keys referring to XLSTAT. No Go.

(Office 10 can be Office 11 etc... in the above paths)

So where did I find the offending .xla?

C:\Documents and Settings\YourUserName\Application Data\Microsoft\Excel\XLStart\XLSTART.XLA

I was initially confused by the XLSTART.XLA file rather than XLSTAT.XLA add-in I was looking for, but holding the arrow over that file showed it belonged to XLSTAT. (I had ealier checked my entire directory for XLSTAT.XLA)

Anyway, there you have it. Fixed at long last. Hope this helps someone.

k.