
String manipulation in VBA
Jonathan
Over the last year I've had problems with Left at some occasions on a
certain client machine, Word97, SR1, Win95. Only last week it occurred.
After rebooting the problem disappeared. No third-party controls has been
used on the particular workstation, from what I know.
--
/Anna Bohman
----------------------------------------------------------------------------
Bra Utbildning AB, Sundsvall, Sweden
----------------------------------------------------------------------------
Quote:
>Hi Greg,
>The one time I heard of this happening was when using a beta version of a
>third-party VB control, and control had a Left property. Setting the
>compiler options wrong when compiling the control meant that the Left
>property interfered with the Left() function of VBA. Using the
VBA qualifier
>was the workaround until a fix was made (fortunately very quickly)
>Regards
>Jonathan West - Word MVP
>MultiLinker - Automated generation of hyperlinks in Word
>Conversion to PDF & HTML
> http://www.*-*-*.com/
>Word FAQs at http://www.*-*-*.com/
>Please post any follow-up in the newsgroup. I do not reply to Word
questions
>by email
Quote:
>>Anna,
>>I didn't really investigate why, but I had similar problems with some vba
>>functions and used the library qualifier, hence, VBA.Chr instead of plain
>>Chr.
>>FWIW,
>>Greg Longtin
>>> Jonathan
>>> Thanks. Those are the common ones. The problem is long gone but the
error
>>> occurred at every Errorhandler containing a MsgBox with Chr(13) in the
>>text,
>>> there was a problem at the customers office, NT4, Word97. Replacing it
>>with
>>> vbCr made the difference. Doesn't make sense to me.
>>> --
>>> /Anna Bohman
>>> ------------------------------------------------------------------------
-
>-
>>--
>>> Bra Utbildning AB, Sundsvall, Sweden
>>> ------------------------------------------------------------------------
-
>-
>>--