Hello all,

I am trying to Dim some text as a variable for another macro of mine. For example, the value I want to Dim is located between the words "to host the" and "group at the location". Once I have the variable, I want to use it to fill in other paragraphs throughout my document, something like this -



Any solutions to how I could go about this?

Your terminology is not good. You are actually trying to replace a word in a range with a field/content control/bookmark.

When you say you want to use this 'variable' to fill in other paragraphs - does this mean you want just the value of this variable (ie 'designated') to be replicated in other locations or that the value of this variable causes other text to change based on other parameters?

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia

You're right, I poorly misconstructed what I'm looking for. I am trying to give the variable a value so that I can place it in new paragraphs that I'm generating that have "xxxx" within them (where I want that variable to be). I'm trying to replace the xxxx with the variable instead of just manually copying and pasting it from the original paragraph. Is that clearer?

So if the word I want is "either "Florida" or "California", and it always generates in between two words (Let's just say "of" and "State", but both are unique to the document), I want to then have my macro take whichever state it is and replace "xxxx"throughout my document with it.

OK, so I would do this by using a Content Control linked to a document property. This is easiest to do by using one of the 'built-in' metadata fields by going to Insert > Quick Parts > Document Property (and choosing one, say 'Company'). This can then be copied to other locations (or inserted the same way) to get a result where editing any one of these results in the others automatically updating.

If you need this happening via vba you can copy that range to the clipboard ie "The event is to be held with the ContentControl group at the location" and then include the contents of the clipboard in your VBA code eg

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia

Hm, this might not be a viable solution for me, unless I'm reading this wrong. Here's another scenario I have - A company name always generates in the first paragraph between the words "The company " and " shall be responsible for". I want to be able to, using vba, take that company name and replace every "XXXXXX" throughout my document. Without using one of the built-in options, is there a way I could put this into code, knowing the place the company name always generates is unique?