Re: Using VBA to replace text



Did you change MatchWholeWords to be False? I was able to do the replace
in my test run without the end character when I did that.
--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:27r7511vb1tf9caftq66562k544h2kfltc@xxxxxxx:

> I suspect that the character ended up being changed when the lines
> were added to the newsgroup message. Either that or in the Outlook
> message I used to send to code from one computer to this one.
>
> The code gave me exactly what I needed although I don't know why I
> needed to include the end character in the find criteria. I can find
> just the year and change it with no problems. I could also change a
> single word in the line with no problems. I changed "registered" to
> "doofratz" to test the code. Apparently changing a phrase needs the
> line delimiter. Pretty weird.
>
> I ran a test against multiple presentations in a folder and it changed
> all that had title and slide masters. I need to capture the situation
> where I don't have either but I don't expect that to be a problem.
> (Famous last words. <giggle>)
>
> Thank you again.
>
>
> Jeff
>
> On Wed, 06 Apr 2005 06:23:58 -0700, "David M. Marcovitz"
> <marcoNOSPAM@xxxxxxxxxx> wrote:
>
>>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
>
>

.



Relevant Pages

  • Re: Text to column fixed length
    ... "IanC" wrote: ... specific character, after a single word, specific number of words etc? ... work accurately either or using fixed width or delimiters with a space or ...
    (microsoft.public.excel.misc)
  • Re: Text to column fixed length
    ... specific character, after a single word, specific number of words etc? ... work accurately either or using fixed width or delimiters with a space or ... Is there a free download available for this ...
    (microsoft.public.excel.misc)
  • Re: editing problems in excel
    ... option and enter a break every character in the next stage of the wizard ... Microsoft MVP - Excel ... >I have a series of numbers edited in word as a single word ex: ...
    (microsoft.public.excel.misc)
  • Re: Reverse large files
    ... ABCDE and B is in bold, and you end up with EDCBA, do you want B or D to be ... (ie is it the character or the character *position* that retains the ... What do you want to do about styles and paragraph formatting? ... characters within a selection, whether that is just a single word, a ...
    (microsoft.public.word.vba.general)
  • Re: msh 3.1 providers -- escaping the colon character.
    ... Jeff Jones [MSFT] ... the child names in generated paths may contain a colon ':' character. ... How can I escape this? ... using a backtick doesn't work as I still get a ...
    (microsoft.public.windows.server.scripting)

Loading