Re: Compile error in hidden module

On Wed, 19 May 2010 18:43:54 +0100, Charles Williams wrote:


When I try to load a particular add-in(*) I get "Compile error in
hidden module". I've checked the usual suspects, but I can't find the
cause. I have of course left a message for the author, but after
three days with no reply I expect I won't get one. Suggestions?

Here's my setup:

* Windows XP, Excel 2003

* nothing in any XLSTART folder

* no custom folder specified in Tools » Options » General

* no other add-ins except Solver and the two Analysis Toolpaks

* macro security Medium; "Trust all installed add-ins and templates"
checked

* both before and after loading the add-in, I checked in VB Editor
Tools » References and nothing is shown as "missing"


(*) TM Plot Manager, from
http://www.tushar-mehta.com/excel/software/plot_manager/


Try using Excel detect and repair (under Help) - this often (but not
always) fixes this kind of problem

Thanks for the thought. Unfortunately, Detect and Repair completed
successfully, but after re-adding the add-in I still get "Compile
error in hidden module: Thisworkbook".

It's not third-party add-ins in general: I'm still able to run
Palisade Corp's @RISK, for instance. This Tushar Mehta guy's site
looks like he's an Excel expert, but maybe there really is just a
coding error in his TM Plot Manager add-in.


--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com
Shikata ga nai...
.

Relevant Pages

  • Compile error in hidden module
    ... hidden module". ... I've checked the usual suspects, ... no custom folder specified in Tools » Options » General ... both before and after loading the add-in, ...
    (microsoft.public.excel)
  • Re: Shared Add-ins just dont work
    ... Since posting I have succeeded in getting an automation add-in to ... the Excel instance. ... OnStartupComplete(ref custom); ... IDTExtensibility2 interface. ...
    (microsoft.public.office.developer.automation)
  • Re: CLEAN function - macro??
    ... In excel 2007 I can add that add-in to the most used commands or quick ... want to clean, and then click a toolbar item to do the clean. ... learn the count of selected cells in the worksheet, ...
    (microsoft.public.excel.worksheet.functions)
  • Re: .net Com Add-in IDTExtensibility type library could not be loaded
    ... > I have been developing an Excel Add-in and had made many successful ... Shared Addin project, I noticed that the IDTExtensibility2 Interface ...
    (microsoft.public.office.developer.com.add_ins)
  • RE: Weird AddIn behaviour
    ... key if the add-in is of the same name. ... The code must reside outside of Excel ... / VBA because anything you do to the registry will be overwritten when you ... opens the file from the original path. ...
    (microsoft.public.excel.programming)