VBA Macro Excel to Word replace all

[clilley113]

Hi Everyone,

Does anyone know of simple VBA macro code that I can use to make data in excel cells auto replace phrases in a word document?

For example if I have data in B:3 and I want it to be input into a word document where the word 'ofice' is. how would I go about doing this.

or is there an easier way of doing this?

Any help would be much appreciated.

Thanks

Chris

[Neil_]

Open your Word document. Press Ctrl H. Type 'ofice' in find. Type the phrase you want to replace it with in 'replace with'. Replace all. If you must do it by macro, why get Excel involved? Word supports VBA.

If you want to use abbreviations or auto-correct common mistakes you make, use Word's 'Auto correct' feature in File>Options>Proofing

[Tinbendr]

of simple VBA macro code

Moderate is how I would describe it.

Are all the replacements in one Word file?

Is this like a template Word file?

A sample file of each would be helpful. (You can upload here. Scroll down to Manage Attachments.)

[clilley113]

Thanks Tinbendr.

I have added the check list I use plus a sample block of text. The report is basically a template where I need to do around 12 'replace all' tasks before I can add my manual wording.

It would be really handy if I could automate the checklist to do these for me.

Thanks

[Tinbendr]

OK, give this a try.

Rename the docx file to a dotx file. (Website thinks it's invalid.)

Change the paths as required.

Please Login or Register  to view this content.

This code is kinda fixed, but easy to understand and modify.

I would tend to write a table, like sheet2, to handle a situation like this. (See the second macro.)