Replace word in MS Word with varable from MS Excel

Hi everyone, I'm hoping someone could help me with this issue I'm having:

I am in the middle of automating a process here at work, the program takes a word, "pencil" for example, from excel. It will then open up a word document with content already in it (premade template). The program will then find all instances of a string, "placepencilhere" for example, and will replace that instance with the string from excel.

Basically I want to be able to take a variable that has a stored string value from excel and use it to replace another variable in a word document.

I tried recording a replace (ctrl+f, replace tab) macro, copying the code, and inserting it into the excel vba code.. but I get a error message. Here is what I have:

---

Please Login or Register  to view this content.

---

Any help is appreciated! Thanks in advance!

odo-

Welcome to the forum, odo.

Please take a few minutes to read the forum rules, and then edit your post to add code tags.

Are you automating this from within Word, or from within Excel? If from within Excel, Selection refers to the selection in Excel.

Notice how I set a reference to the word object.

You used late binding so word variables like wdReplaceAll would mean nothing. You can use early binding, late binding or a combination of the two. Since I set the object, intellisense works even though the code uses late binding's CreateObject(). In Word's VBA Immediate Window, type ?wdReplaceAll and press enter to see the value of 2.

Notice how I prefixed appWrd to Selection as shg explained.

Please Login or Register  to view this content.

Kenneth, you're using late binding. The OP is using early binding.

Originally Posted by Kenneth Hobson

Notice how I set a reference to the word object.

You used late binding so word variables like wdReplaceAll would mean nothing. You can use early binding, late binding or a combination of the two. Since I set the object, intellisense works even though the code uses late binding's CreateObject(). In Word's VBA Immediate Window, type ?wdReplaceAll and press enter to see the value of 2.

Notice how I prefixed appWrd to Selection as shg explained.

Please Login or Register  to view this content.

Hi! Thanks for your reply. I am writing this in Excel, I will play around with your code to see whats going on. I'll check out what early binding/late binding is. Is this code for Excel or Word? I'm a little confused by what you mean "In Word's VBA Immediate Window, type ?wdReplaceAll and press enter to see the value of 2."

Try this:

Please Login or Register  to view this content.

You MUST set reference to Microsoft Word xx.x Object Library

As Kenneth point out, early and late binding both have their advantages.

Early binding is faster at run-time, and you get IntelliSense.

Late binding allows Excel to choose from several versions of a library, which is convenient if you're deploying an application to users who may have various versions of (in this case) Word.