Find and replace with a macro, problem with letter case

garcanrya · #1 01-10-2014, 02:38 AM

Hello,

hope you can help me. I'm trying to tidy some xml-code with Word macros (find and replace) - don't ask me why I have to do it with Word. ;-) For some reason the replacement text starts with a capital letter. Can you tell me what's wrong with my vba?

Code:

    Selection.Find.Replacement.ClearFormatting
    With Selection.Find
        .Text = "AgeElement"
        .Replacement.Text = "age"
        .Forward = True
        .Forward = True
        .Wrap = wdFindContinue
        .Format = False
    End With
    Selection.Find.Execute Replace:=wdReplaceAll

Why is the result: <age>26</Age>? The result I want is <age>26</age>.

Thank you very much!
-garcanrya

macropod · #2 01-10-2014, 04:21 AM

Try adding:
.MatchCase = True

garcanrya · #3 01-10-2014, 05:40 AM

Thanks, macropod, this helped!
greetings,
garcanrya

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Is the following too complex for find/replace macro?	bertietheblue	Word VBA	12	11-04-2013 05:35 PM
Find - Replace Macro using a table list	mdw	Word	0	08-01-2013 04:36 PM
Find and Replace Format macro issue	Jack	Word VBA	2	12-12-2012 09:24 PM
macro or find/replace	JamesVenhaus	Word	2	02-27-2012 03:34 PM
Find and Replace Macro - A Better Way	Tribos	Word VBA	0	10-08-2008 03:22 AM