Re: I was given this macro from this group

From: Steved (anonymous_at_discussions.microsoft.com)
Date: 02/04/05 

Date: Thu, 3 Feb 2005 22:15:27 -0800

Hello from Steved

I am very new at this and have no idea about the
terminology and subsequently i've now have no idea
what to do with your kind answer. Please understand
the reason I came to this sight is to get an answerto my
issue, and the end result would be that it works. You are
asking me to understand code which is new to me so please
if you would bare with me please just show me how I can
get your macro to function. In other words a) and b)I
cannot comprehend.

Thankyou.

>-----Original Message-----
>By now you should have learned enough about coding to
actually read and
>think about these code snippets. You can't just paste
them into a module and
>pray.
>
>a) Insert, in place of Range.Text, whatever string
you're working with.
>
>b) Declare all the variables.
>
>
>
>
>
>"Steved" <anonymous@discussions.microsoft.com> wrote in
message
>news:03c101c50a79$d2c98570$a501280a@phx.gbl...
>> Hello from Steved
>>
>> The below macro Keeps highlighting the belowand will
not
>> work please help.
>>
>> pWords = Split(Range.Text, " ")
>>
>>
>> Sub Testing()
>> Dim pWords() As String
>> pWords = Split(Range.Text, " ")
>> For i = 0 To UBound(pWords)
>> If pWords(i) Like "[a-zA-Z]{1,}" Then
>> pStartWord = i
>> Exit For
>> End If
>> Next
>>
>> Output = pWords(pStartWord)
>> For i = pStartWord + 1 To UBound(pWords)
>> Output = Output & " " & pWords(i)
>> Next
>> End Sub
>
>
>.
>

Relevant Pages

  • Re: I was given this macro from this group
    ... By now you should have learned enough about coding to actually read and ... think about these code snippets. ... Insert, in place of Range.Text, whatever string you're working with. ... > Sub Testing() ...
    (microsoft.public.word.vba.general)
  • Compile-time text/string manipulation
    ... A "compile-time language" is one that processes ... Compile time languages for assemblers ... This group includes macro ... requires access to various string and text manipulation ...
    (alt.lang.asm)
  • RE: Search email for text string to use in filename - save email t
    ... The code for my macro is below. ... .MatchWholeWord = False ... Dim sNewFileName As String ... > 0 Then Exit Function ...
    (microsoft.public.outlook.program_vba)
  • Re: Document Property to display more than 1 line
    ... then use the following macro to identify the character ... Dim strNums As String ...
    (microsoft.public.word.newusers)
  • Re: Form refresh code
    ... Your version of the InserrtAddress macro also unlocked the field with the ... string variable name in the protect/unprotect commands. ... Public Sub InsertAddressFromOutlook() ... Dim strCode As String, strAddress As String ...
    (microsoft.public.word.docmanagement)