Difference between Strings.Left and Left? 
Author Message
 Difference between Strings.Left and Left?

Hi folks,

Do you know what is the difference bew{*filter*} Strings.Left and Left?

and also Strings.left$
(This one seems to return a string, the former one is not typed?)
and what about Strings.leftB and Strings.leftB$ ????

Regards,

Phil

*** Sent via Developersdex http://www.*-*-*.com/ ***
Don't just participate in USENET...get rewarded for it!



Thu, 03 Nov 2005 18:52:14 GMT  
 Difference between Strings.Left and Left?
Left$ returns a String data type.
Left returns a Variant data type.

Same explanation for other functions having two such forms.

--
http://www.*-*-*.com/ ; Howard Kaikow's web site.
------------------------------------------------

Quote:

> Hi folks,

> Do you know what is the difference bew{*filter*} Strings.Left and Left?

> and also Strings.left$
> (This one seems to return a string, the former one is not typed?)
> and what about Strings.leftB and Strings.leftB$ ????

> Regards,

> Phil

> *** Sent via Developersdex http://www.*-*-*.com/ ***
> Don't just participate in USENET...get rewarded for it!



Thu, 03 Nov 2005 19:13:02 GMT  
 Difference between Strings.Left and Left?
Thanks Howard, but do you know when it's preferable to use
Strings.Left$ rather Left$
and when do we use Strings.LeftB$
?
May be Left$ is a shortCut for Strings.Left$

I noticed that LeftB and LeftB$ exist also
Unfortunately, I did not find any explanation either in
the MSDN Online Help or by pressing F1!

Regards,
Phil

Quote:
>-----Original Message-----
>Left$ returns a String data type.
>Left returns a Variant data type.

>Same explanation for other functions having two such
forms.

>--
> http://www.*-*-*.com/ ; Howard Kaikow's web site.
>------------------------------------------------

message

>> Hi folks,

>> Do you know what is the difference bew{*filter*} Strings.Left
and Left?

>> and also Strings.left$
>> (This one seems to return a string, the former one is
not typed?)
>> and what about Strings.leftB and Strings.leftB$ ????

>> Regards,

>> Phil

>> *** Sent via Developersdex http://www.*-*-*.com/
***
>> Don't just participate in USENET...get rewarded for it!

>.



Thu, 03 Nov 2005 19:46:16 GMT  
 Difference between Strings.Left and Left?
Thanks Howard, but do you know when it's preferable to use
Strings.Left$ rather Left$
and when do we use Strings.LeftB$
?
May be Left$ is a shortCut for Strings.Left$

I noticed that LeftB and LeftB$ exist also
Unfortunately, I did not find any explanation either in
the MSDN Online Help or by pressing F1!

Regards,
Phil

Quote:
>-----Original Message-----
>Left$ returns a String data type.
>Left returns a Variant data type.

>Same explanation for other functions having two such
forms.

>--
> http://www.*-*-*.com/ ; Howard Kaikow's web site.
>------------------------------------------------

message

>> Hi folks,

>> Do you know what is the difference bew{*filter*} Strings.Left
and Left?

>> and also Strings.left$
>> (This one seems to return a string, the former one is
not typed?)
>> and what about Strings.leftB and Strings.leftB$ ????

>> Regards,

>> Phil

>> *** Sent via Developersdex http://www.*-*-*.com/
***
>> Don't just participate in USENET...get rewarded for it!

>.



Thu, 03 Nov 2005 19:46:04 GMT  
 Difference between Strings.Left and Left?
Left() is the same as:
Strings.Left() which is the same as:
VBA.Strings.Left()

As long as there is a reference to the VBA object model then there is no
need to fully qualify the Left() function.

P


Quote:

> Hi folks,

> Do you know what is the difference bew{*filter*} Strings.Left and Left?

> and also Strings.left$
> (This one seems to return a string, the former one is not typed?)
> and what about Strings.leftB and Strings.leftB$ ????

> Regards,

> Phil

> *** Sent via Developersdex http://www.*-*-*.com/ ***
> Don't just participate in USENET...get rewarded for it!



Thu, 03 Nov 2005 20:26:11 GMT  
 Difference between Strings.Left and Left?
The only time you need to qualify the use of such functions would be when
the project has more than one library with  identically named functions, and
the functionality differs among the libraries.

So far, I've never had a need to use Strings. to qualify such functions.

--
http://www.*-*-*.com/ ; Howard Kaikow's web site.
------------------------------------------------

Quote:
> Left() is the same as:
> Strings.Left() which is the same as:
> VBA.Strings.Left()

> As long as there is a reference to the VBA object model then there is no
> need to fully qualify the Left() function.

> P



> > Hi folks,

> > Do you know what is the difference bew{*filter*} Strings.Left and Left?

> > and also Strings.left$
> > (This one seems to return a string, the former one is not typed?)
> > and what about Strings.leftB and Strings.leftB$ ????

> > Regards,

> > Phil

> > *** Sent via Developersdex http://www.*-*-*.com/ ***
> > Don't just participate in USENET...get rewarded for it!



Thu, 03 Nov 2005 21:37:19 GMT  
 Difference between Strings.Left and Left?
Phobos said:

Quote:
>-----Original Message-----
>Left() is the same as:
>Strings.Left() which is the same as:
>VBA.Strings.Left()
>As long as there is a reference to the VBA object model
then there is no
>need to fully qualify the Left() function.

=====================
Ok, I understand.
Now, I have to explain to you why I'm dealing with the
Strings object although it seems useless.
Someone posted a while ago how he solved the error I'm
dealing with:
"Can't compile, Library is missing" while the de{*filter*}
stopped on words like Mid, Left or LTrim, etc...
He answered that using "Strings.Left" made this error
disapearing.

For sure, the best is to find out which DLL is missing or
is of the wrong Version. (I believe the latter is my
problem because I created my VBA project with Excel XP and
the problem arises on my friend's computer running Excel
2000 Pro).

So, may be using "Strings.Left" will force my VBA project
to use Excel 9.0 library instead of Excel 10.0 library.
Anyway, thanks Phobos for the explanations
Phil

So, I don't know



Thu, 03 Nov 2005 22:12:05 GMT  
 Difference between Strings.Left and Left?
If you use  unqualified references to Left, Left$, etc., each version of
Excel will likely handle those functions correctly.

I expect that your problem lies in other than the Excel library, unless you
are using Excel 2002 VBA that is not supported by earlier versions.

--
http://www.*-*-*.com/ ; Howard Kaikow's web site.
------------------------------------------------

Quote:
> Phobos said:

> >-----Original Message-----
> >Left() is the same as:
> >Strings.Left() which is the same as:
> >VBA.Strings.Left()

> >As long as there is a reference to the VBA object model
> then there is no
> >need to fully qualify the Left() function.
> =====================
> Ok, I understand.
> Now, I have to explain to you why I'm dealing with the
> Strings object although it seems useless.
> Someone posted a while ago how he solved the error I'm
> dealing with:
> "Can't compile, Library is missing" while the de{*filter*}
> stopped on words like Mid, Left or LTrim, etc...
> He answered that using "Strings.Left" made this error
> disapearing.

> For sure, the best is to find out which DLL is missing or
> is of the wrong Version. (I believe the latter is my
> problem because I created my VBA project with Excel XP and
> the problem arises on my friend's computer running Excel
> 2000 Pro).

> So, may be using "Strings.Left" will force my VBA project
> to use Excel 9.0 library instead of Excel 10.0 library.
> Anyway, thanks Phobos for the explanations
> Phil

> So, I don't know



Thu, 03 Nov 2005 22:28:09 GMT  
 Difference between Strings.Left and Left?
When you get the error, go into Tools=>References in the VBE and I belive
you will find a reference marked as MISSING.  This is the source of the
problem and has nothing to do with Left.

Regards,
Tom Ogilvy


Quote:
> Phobos said:

> >-----Original Message-----
> >Left() is the same as:
> >Strings.Left() which is the same as:
> >VBA.Strings.Left()

> >As long as there is a reference to the VBA object model
> then there is no
> >need to fully qualify the Left() function.
> =====================
> Ok, I understand.
> Now, I have to explain to you why I'm dealing with the
> Strings object although it seems useless.
> Someone posted a while ago how he solved the error I'm
> dealing with:
> "Can't compile, Library is missing" while the de{*filter*}
> stopped on words like Mid, Left or LTrim, etc...
> He answered that using "Strings.Left" made this error
> disapearing.

> For sure, the best is to find out which DLL is missing or
> is of the wrong Version. (I believe the latter is my
> problem because I created my VBA project with Excel XP and
> the problem arises on my friend's computer running Excel
> 2000 Pro).

> So, may be using "Strings.Left" will force my VBA project
> to use Excel 9.0 library instead of Excel 10.0 library.
> Anyway, thanks Phobos for the explanations
> Phil

> So, I don't know



Fri, 04 Nov 2005 03:30:29 GMT  
 
 [ 9 post ] 

 Relevant Pages 

1. Prints emails leaving huge Left side margin

2. How to print left and right footers at same location as left and right margin setting

3. Top and left property when using form.top and form.left

4. Sorting by number digits from left to right instead of right to left

5. LEFT and LEFT$

6. subscribes automatically when leaving when leaving newsgroup

7. mixing a Left join into a left join

8. Left Join in a left join

9. right-to-left to left-to-right

10. Changing input from left>right to right>left


 
Powered by phpBB® Forum Software © phpBB Group