Hi,
i wrote an addin for excel 2003/2007. it work well on my computer.

when i copy the xla file to onother computer, i get errors on functions like
LCase, UCase.

i have .NET studio 2005 installed on my machine.
The other has framework 2 and 3.5.

do i have to add any ref declaration or module reference on functions call?

any idea?

thank you in advance,
gadyc

On the other machine, goto the VBIDE (Alt-F11). Goto menu Tool>References.
You will likely see an item in that list with MISSING in the caption.
Uncheck that/those options and you should be good to go.

--
__________________________________
HTH

Bob

"GadyC" <(E-Mail Removed)> wrote in message
news:A37DF58E-8835-461B-9E8F-(E-Mail Removed)...
> Hi,
> i wrote an addin for excel 2003/2007. it work well on my computer.
>
> when i copy the xla file to onother computer, i get errors on functions
> like
> LCase, UCase.
>
> i have .NET studio 2005 installed on my machine.
> The other has framework 2 and 3.5.
>
> do i have to add any ref declaration or module reference on functions
> call?
>
> any idea?
>
> thank you in advance,
> gadyc

Just to add to Bob's response...

I'd look for those MISSING references on a troublesome computer. Then determine
if they're required or not.

If they're not required, then I'd uncheck them from my original workbook project
(on my pc) and redistribute the addin without those references.

If they are required, you're going to have to find out why the troublesome pc's
don't have them.

GadyC wrote:
>
> Hi,
> i wrote an addin for excel 2003/2007. it work well on my computer.
>
> when i copy the xla file to onother computer, i get errors on functions like
> LCase, UCase.
>
> i have .NET studio 2005 installed on my machine.
> The other has framework 2 and 3.5.
>
> do i have to add any ref declaration or module reference on functions call?
>
> any idea?
>
> thank you in advance,
> gadyc

--

Dave Peterson