Anyone?

I have a reference set to MS VBA, MS Access 11 object libary, MS DAO Object
Library, MS ActiveX data object, MS Excel 11 object library, and MS Scripting
Runtime.

At this point everything is working fine. We use "Reflection" to access our
cost system. I would like to add this library "Reflection for ReGIS
Graphics" or "Reflection for Regis Graphics ActiveX Control 1.0 Type Library"
but when I do I get a conflict with one of my modules' "Left()" function.

VBA syntax uses left([string],[number char]) but the Reflection "Left"
function is different it is looking for "object.Left = value" type of syntax.

How do I resolve this "Function Conflict"?
--
Thanks in advance!
**John**

Hi,
you can use VBA.Left to explicitly call VBA function and Reflection.Left to
call other one, where Reflection is exact name of your library

You can also put VBA higher then Reflection in References list, then Left()
will be VBA function

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com


"John" <(E-Mail Removed)> wrote in message
news:FD7A4D23-0C15-4A96-BA31-(E-Mail Removed)...
> Anyone?
>
> I have a reference set to MS VBA, MS Access 11 object libary, MS DAO
> Object
> Library, MS ActiveX data object, MS Excel 11 object library, and MS
> Scripting
> Runtime.
>
> At this point everything is working fine. We use "Reflection" to access
> our
> cost system. I would like to add this library "Reflection for ReGIS
> Graphics" or "Reflection for Regis Graphics ActiveX Control 1.0 Type
> Library"
> but when I do I get a conflict with one of my modules' "Left()" function.
>
> VBA syntax uses left([string],[number char]) but the Reflection "Left"
> function is different it is looking for "object.Left = value" type of
> syntax.
>
> How do I resolve this "Function Conflict"?
> --
> Thanks in advance!
> **John**

Thanks Alex... That cleared it up.
--
Thanks in advance!
**John**


"Alex Dybenko" wrote:

> Hi,
> you can use VBA.Left to explicitly call VBA function and Reflection.Left to
> call other one, where Reflection is exact name of your library
>
> You can also put VBA higher then Reflection in References list, then Left()
> will be VBA function
>
> --
> Best regards,
> ___________
> Alex Dybenko (MVP)
> http://accessblog.net
> http://www.PointLtd.com
>
>
> "John" <(E-Mail Removed)> wrote in message
> news:FD7A4D23-0C15-4A96-BA31-(E-Mail Removed)...
> > Anyone?
> >
> > I have a reference set to MS VBA, MS Access 11 object libary, MS DAO
> > Object
> > Library, MS ActiveX data object, MS Excel 11 object library, and MS
> > Scripting
> > Runtime.
> >
> > At this point everything is working fine. We use "Reflection" to access
> > our
> > cost system. I would like to add this library "Reflection for ReGIS
> > Graphics" or "Reflection for Regis Graphics ActiveX Control 1.0 Type
> > Library"
> > but when I do I get a conflict with one of my modules' "Left()" function.
> >
> > VBA syntax uses left([string],[number char]) but the Reflection "Left"
> > function is different it is looking for "object.Left = value" type of
> > syntax.
> >
> > How do I resolve this "Function Conflict"?
> > --
> > Thanks in advance!
> > **John**
>
> .
>

=?Utf-8?B?Sm9obg==?= <(E-Mail Removed)> wrote in
news:FD7A4D23-0C15-4A96-BA31-(E-Mail Removed):

> I have a reference set to MS VBA, MS Access 11 object libary, MS
> DAO Object Library, MS ActiveX data object, MS Excel 11 object
> library, and MS Scripting Runtime.
>
> At this point everything is working fine. We use "Reflection" to
> access our cost system. I would like to add this library
> "Reflection for ReGIS Graphics" or "Reflection for Regis Graphics
> ActiveX Control 1.0 Type Library" but when I do I get a conflict
> with one of my modules' "Left()" function.
>
> VBA syntax uses left([string],[number char]) but the Reflection
> "Left" function is different it is looking for "object.Left =
> value" type of syntax.
>
> How do I resolve this "Function Conflict"?

By specifying the parent library, as Alex has explained.

But I'd say you shouldn't add any references at all beyond the first
3 you list, and do all the rest with late binding. Then you wouldn't
have this problem at all.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/