Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 22
Default compile error in hidden module with excel 2003

Hello Excellers,

I have a user that is using Excel 11.0, build 5612 (Excel 2003). When he
starts up my addin he gets "Compile error in hidden module: myModule_Name".

I have tested with excel 11.0, build 6113, and I don't get any errors.

Does anyone know what the problem might be?

Thanks,

Brian Murphy
Austin, Texas


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,718
Default compile error in hidden module with excel 2003

I find that most the time this is due to an unrecognized constant (like
xlABC), but it should be easy to debug. Just unlock the VB project in the
add-in and then the module won't be "hidden" any more so you should get a
Debug button with the error message.

--
Jim Rech
Excel MVP
"Brian Murphy" wrote in message
...
| Hello Excellers,
|
| I have a user that is using Excel 11.0, build 5612 (Excel 2003). When he
| starts up my addin he gets "Compile error in hidden module:
myModule_Name".
|
| I have tested with excel 11.0, build 6113, and I don't get any errors.
|
| Does anyone know what the problem might be?
|
| Thanks,
|
| Brian Murphy
| Austin, Texas
|
|


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 22
Default compile error in hidden module with excel 2003

Thanks, Jim.

I was already thinking about sending him an unprotected addin to see what
that would tell me. So now I'm definitely going to do that.

Based on some recent changes I've been making, I can see that it might be a
bum constant name.

Brian



"Jim Rech" wrote in message
...
I find that most the time this is due to an unrecognized constant (like
xlABC), but it should be easy to debug. Just unlock the VB project in the
add-in and then the module won't be "hidden" any more so you should get a
Debug button with the error message.

--
Jim Rech
Excel MVP
"Brian Murphy" wrote in message
...
| Hello Excellers,
|
| I have a user that is using Excel 11.0, build 5612 (Excel 2003). When

he
| starts up my addin he gets "Compile error in hidden module:
myModule_Name".
|
| I have tested with excel 11.0, build 6113, and I don't get any errors.
|
| Does anyone know what the problem might be?
|
| Thanks,
|
| Brian Murphy
| Austin, Texas
|
|




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
When i open excel, i i get: Compile error in hidden Module, HELP! Snoopy Excel Discussion (Misc queries) 1 February 19th 09 03:07 PM
Compile error in hidden module Excel 2007 jgt1942 Excel Discussion (Misc queries) 1 October 20th 08 01:31 PM
excel 2007 - compile error in hidden module - modcustomfunctions David Excel Discussion (Misc queries) 7 May 4th 07 12:21 PM
Compile error in hidden module in excel 2002 X2002 Excel Discussion (Misc queries) 1 March 5th 07 02:32 PM
compile error in hidden module autoexec.new in excel 2003 maurice Charts and Charting in Excel 1 January 1st 07 06:13 PM


All times are GMT +1. The time now is 11:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"