Excel 2000 Vs Excel 2002 - Compile Error
 

I've never written compiled addin, but this is what I'd check for a regular
..xla/.xls.

Look under Tools|References (in the VBE) in one of the problem (xl2002) pcs.

I bet you'll find one that's marked missing. Uncheck it. (A missing reference
will cause the procedure to not compile--and might point at any old line.)

Then you'll have to decide if your code actually needs that reference. If it
doesn't, you can go back to your pc (where you authored the macro) and
tools|references and remove the missing reference.


Aanika wrote:

All,

I have written an xla file using the Visual Basic editor
in Excel 2000 which works fine.

However once I built an exe and installed this on a PC
with Excel 2002 it came up with a comiple error
stating "Compile error in hidden module: OnlineModule".
OnlineModule is the name of the Module which I have
written. When I opened the OnlineModule the Visual Basic
editor was pointing at the use of an Excel library
function 'String()'.

Im not sure why this compile error occurred, I would be
grateful if someone could give me some hindsight into
this issue and also how to get around it.

Thanks

Aanika

--

Dave Peterson