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

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
|
|

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
|
|