Word Vba run from Excel

[kamaflage]

Hi Experts,


I have a excel macro that is activating my word macro.

in the excel macro when I have

Please Login or Register  to view this content.

everything works however
when i set

Please Login or Register  to view this content.

the below codes do not work. Please advise as to what i am doing wrong since I would prefer to use

Please Login or Register  to view this content.

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

[macropod]

Why are you working with a Selection, instead of Range objects? What, exactly, are you trying to delete?

[kamaflage]

Hi acropop,

Below is the word vba and also a sample file, hope this helps to explain what i am doing.

Please Login or Register  to view this content.

test file.docx

[macropod]

Try the following:

Please Login or Register  to view this content.

[kamaflage]

Hi macropod,

your code works perfectly however i need to add the below condition.
I know that the below does not currently work, just wanted to better explan.


If find condition is true then delete the find line and also the 2 first instances of Text = Chr(12)
else just delete the first instance of Text = Chr(12)

I hope this makes sense.

Please Login or Register  to view this content.

[macropod]

You should be able to achieve what you want by changing:

Please Login or Register  to view this content.

in the code I posted to:

Please Login or Register  to view this content.

[kamaflage]

Hi Macropod,

Your suggestion worked perfectly.

Can you please explain in detail how the below codes work or point me to the resource to read. The characters and symbols are throwing me off.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[macropod]

Those are just wildcard Find/Replace expressions. See:
https://support.office.com/en-us/art...5-aa991160eafb
http://www.gmayor.com/replace_using_wildcards.htm