VBA for Word

[hellsreach]

I am attempting to write a script in VBA for Word. I am reasonable familiar with VBA in Excel, but my VBA/Word skills are significantly weaker.

What I want to do in automatically change a date plus a few other values. The problem is, I don't automatically know what the date or value is prior to running the macro.

I was hoping there was a way to find a particular piece of text (lets say "in the amount of") and the offset that by 1 word (pretend it previously said $5000), then change to "$7000"

Anyone know how to accomplish this?

 

[Eric W]

Like you, I've done much less VBA in Word. I know you can do it the way you describe (with some difficulty). However, I know you can insert variables in your Word document. Then you can update all the variables via VBA, then update the variables all at once. Here are a couple links:

https://support.microsoft.com/en-us/help/306281/how-to-store-and-retrieve-variables-in-word-documents

Update fields - Microsoft Support

Update one or all fields in your document.

support.office.com

I experimented with those, and got it working in about 5 minutes. Try it out and let us know how it works.

 

[Macropod]

All of what you've described can be done via Find/Replace in Word - including with wildcards for unknown values & dates. That said, why are you trying to do that rather than using a template?

Find/Replace operations in Word can be implemented via macros (I've written many) but, without knowing exactly what you want to do, it's impossible to write such a macro.