Anyone any ideas about Word macros?

[Domski]

Hi,

Thought I'd see if anyone here had any thoughts on this:

http://www.theofficeexperts.com/forum/showthread.php?t=8367

I'm pretty cr@p with VBA in general and a complete novice in Word. Iexpected I'd just be able to run the macro as in excel but it doesn't appear to be the case.

Dom

 

[Damon Ostrander]

Hi Domski,

Running a macro in Word is just like in Excel. Tools > Macro > Macros.

The macro can also be assigned to a button, in the same way you would do it in Excel.

One thing you need to watch out for when adding the macro to a Word document. It is quite easy to accidentally place the macro in the Normal template rather than in the document. This is fine if you want the macro to be available in every Word document. But if the macro is unique to the document you are editing, in the Visual Basic Editor, be sure that you add the new macro module to the Project (DocumentX) project.

Damon

 

[Macropod]

Hi,

The code you're referring to is apparently meant to be run from a userform named 'QueryForm' - you can see that from the CloseBtn_Click sub. It seems that form has at least 3 buttons: CloseBtn, FindBtn and ReplaceBtn.

Without the form and those buttons, you could get the code to run by deleting the word 'Private' from these two subs:

Private Sub FindBtn_Click()
' just find, no replace
Call DoReplace(wdReplaceNone)
End Sub

Private Sub ReplaceBtn_Click()
' replace it
Call DoReplace(wdReplaceAll)
End Sub

then selecting either macro in the normal way.

Cheers