Re: Using VBA to replace text

Great. I'm glad this worked for you, and I'm glad my little code snippet
helped. I just wonder why I got 11, and you got 13. Oh well...as long as
it's working.
--David

--
David M. Marcovitz
Microsoft PowerPoint MVP
Director of Graduate Programs in Educational Technology
Loyola College in Maryland
Author of _Powerful PowerPoint for Educators_
http://www.loyola.edu/education/PowerfulPowerPoint/

Jeff Jones <jpjones23@xxxxxxxxxxxxx> wrote in
news:3j665158lonn5rfths1ieh29um46apkfb9@xxxxxxx:

> Whew......
> I finally got it, with the help of your snippet of code. I ran it
> against the textbox and the line breaks were Chr$(13)'s with a Chr$32)
> thrown in. That was a good idea! I'll remember it the next time I
> have such an opportunity.
>
> I cut the find string back to just the line I wanted to change along
> with the Chr$(13) and I finally got a match.
>
> This has certainly been a pain in the database. I truly appreciate
> your patience and sticking with this wonderfulness until I finally got
> it. Don'tcha just love technology? <giggle>
>
> Thank you again.
>
> Take care,
> Jeff
>
> On Tue, 5 Apr 2005 15:07:04 -0700, David M. Marcovitz
> <DavidMMarcovitz@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
>
>>11
>>
>>That is, your number for a new line is not 13 or 10 or 10 followed by
>>13. It is 11. How do I know:
>>
>> For Each mychar In oShp.TextFrame.TextRange.Characters
>> If getReady Then
>> MsgBox Asc(mychar) & " is the number."
>> End If
>> If mychar = "." Then
>> getReady = True
>> Else
>> getReady = False
>> End If
>> Next mychar
>>
>>Each of your new lines came after a period, so I wrote this little
>>script to figure out what the ASCII value of the character after
>>period was, and it came back with 11. Also, change your WholeWords to
>>False (I don't know if that is necessary, but I changed it while I was
>>testing something, and it made something work).
>>
>>Just be careful that all your text is identical, including, not having
>>any extra spaces.
>>
>>--David
>>
.

Relevant Pages
Loading