VBA Automation error
 

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

VBA Automation error
 

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" wrote in message
...
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




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

VBA Automation error
 

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

NickHK

"Bernard Bourée" wrote in message
...
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




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