VBA Automation error

[Bernard Bourée]

I have a xla in development and it was working fine
I have moved it from one PC to an other and get an error
"Automation error"
on a line: Dim Plage as Range

Can someone help ?
Thanks

[Bernard Bourée]

Bernard Bourée a écrit :
> I have a xla in development and it was working fine
> I have moved it from one PC to an other and get an error
> "Automation error"
> on a line: Dim Plage as Range
>
> Can someone help ?
> Thanks
Some details

Now when I open the file I get a message telling that the program in on
the point to load a "non secure" ActiveX, but I have trust the source I
can go on abd click OK which I have done.
THen I get error "Automation Error" without more details.
The only non usual component I use is RefEdit see image attached of my
references.
Thanks for your help

Bernard

[Peter T]

Hi Bernard,

Were all references in the xla set to the lowest version of any user,
including XL version.

I wasn't aware that the RefEdit required trusting, but do you have a
RichTextBox.

Regards,
Peter T

"Bernard Bourée" <bernard@bouree.net> wrote in message
news:el6MJpevGHA.4688@TK2MSFTNGP06.phx.gbl...
> Bernard Bourée a écrit :
> > I have a xla in development and it was working fine
> > I have moved it from one PC to an other and get an error
> > "Automation error"
> > on a line: Dim Plage as Range
> >
> > Can someone help ?
> > Thanks
> Some details
>
> Now when I open the file I get a message telling that the program in on
> the point to load a "non secure" ActiveX, but I have trust the source I
> can go on abd click OK which I have done.
> THen I get error "Automation Error" without more details.
> The only non usual component I use is RefEdit see image attached of my
> references.
> Thanks for your help
>
> Bernard
>
>


----------------------------------------------------------------------------
----

[NickHK]

Does this help ?
http://support.microsoft.com/default...b;en-us;827742

NickHK

"Bernard Bourée" <bernard@bouree.net> wrote in message
news:el6MJpevGHA.4688@TK2MSFTNGP06.phx.gbl...
> Bernard Bourée a écrit :
> > I have a xla in development and it was working fine
> > I have moved it from one PC to an other and get an error
> > "Automation error"
> > on a line: Dim Plage as Range
> >
> > Can someone help ?
> > Thanks
> Some details
>
> Now when I open the file I get a message telling that the program in on
> the point to load a "non secure" ActiveX, but I have trust the source I
> can go on abd click OK which I have done.
> THen I get error "Automation Error" without more details.
> The only non usual component I use is RefEdit see image attached of my
> references.
> Thanks for your help
>
> Bernard
>
>


----------------------------------------------------------------------------
----