17 replies to this topic

[Josh Bond]

Now that I have that setup in Word, that will make things easier. Not sure why I never thought of your idea before. I've been typing Alt-0247 to produce the divide symbol. Uggghhh...

[BaptizedBeliever]

um...no Macros are showing up for me to edit. Am I missing something here?

[Josh Bond]

Oh ok, well then Create one with the Create button on the screen where you would normally find existing macros.

Normally, if you were doing search/replace macros or other commands, you would just record the macro. 99% of the time that works. Because you wanted something inserted that's not on the clipboard, we have to manually define the macro. You just need to get to the macro edit screen. Create should do it. Just replace the newly created sample macro code with my code.

[BaptizedBeliever]

ok, got that taken care of. 'Twas a lot of time, but now I can just hit ctrl-m and I've now got my mark. It is a lot easier for me to be able to do this in Word than to work back and forth between Word and ToolTip before doing the final conversion.

Thanks, Josh!

[DSaw]

Cobb78

Another way to get rid of text you don't want that is formatted the same is Highlight it right click then select text with similar formatting and all of the same text say all bold text will highlight then press delete

also this could be used to change the text formatting to something else

Edited by DSaw, 06 December 2011 - 02:41 PM.

[SpreadTheWord]

Ok my turn.

I recorded a macro that does a lot of regular expression search and replacements. I have edited it here and there and it's working great. I'm having to run it on certain chapters and I have to change the replacement text in several places before I can run it each time. Mostly Im changing out bible book names. I'm worried with me manualy editing macro each time sooner or later i will make a mistake and then I'll have made a mess of my text. When I run my macro, can MS Word 'ask' me the name of a bible book? And then have my answer appear in the macro instead of me editing the macro?

[Josh Bond]

You're right about being bored or tired and making a mistake editing a macro.

Here's some code from one of my macros I'm currently using on a project. I've removed some of the text to make it a simple example to get you started

BookName = InputBox("Book Name")
  
'...Text omitted for the purposes of an easy example...

.Replacement.Text = "÷" + BookName

The purple text creates a variable called BookName. The InputBox causes Word to popup an input box where you can enter the value. The value you enter will be stored in BookName. (Gotta love Visual Basic, how much easier could this be?)

So you want the Bible book name you enter to be used in your replacement text? Just refer to the BookName variable in your replacement text. You should be familar with the .Replacement.Text command from your recorded macro.

Keep your literal replacement text in quotes (as it already is). And break up your replacement text so that where you've been editing the Book name manually, the BookName variable will now appear. Don't put Bookname in quotes. But do use + signs. If you have literal replacement text to go to the right of BookName, just enter a + sign to the right of BookName, followed by the literal replacement text in quotes.

In the example above: ÷ (in quotes so Word knows its a literal) and + BookName (no quotes because its a variable). So if you entered "Matthew" into the input box, then the replacement would be: ÷Matthew. Easy enough.

 word_input_box.png   16.28K   0 downloads

[SpreadTheWord]

Works perfectly, thank you so much!

I just looked up word macros and visual basic and you can just about write a tooltipping program in MS Word!