compile error in hidden module with excel 2003

[Brian Murphy]

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

 

[Jim Rech]

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

 

[Brian Murphy]

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