How to Dim a substring between two strings

dwirony · #1 10-27-2016, 09:56 AM

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 -

Code:

With Selection.Find
        .Text = "The event is to be held with the designated group at the location"
        .Replacement.Text = "The event is to be held with the " & Dim VARIABLE & " group at the location"
    End With
    Selection.Find.Execute Replace:=wdReplaceAll

Any solutions to how I could go about this?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to substring and trim in excel	Mahesh G	Excel	0	08-16-2016 06:03 AM
Substring to return numbers	funkyfido	Excel	4	07-22-2016 10:03 AM
How to link similar strings.	PRA007	Word VBA	2	01-20-2016 04:22 AM
Search with multiple strings	silverspr	Excel	7	03-03-2013 04:45 PM
update style of all strings available between two specific strings	vikrantkale	Word	1	03-28-2011 06:13 PM