Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-27-2016, 02:52 PM
Guessed's Avatar
Guessed Guessed is offline How to Dim a substring between two strings Windows 10 How to Dim a substring between two strings Office 2013
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,158
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default


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
Reply With Quote
  #2  
Old 10-27-2016, 03:00 PM
dwirony dwirony is offline How to Dim a substring between two strings Windows 7 64bit How to Dim a substring between two strings Office 2003
Advanced Beginner
How to Dim a substring between two strings
 
Join Date: Oct 2016
Posts: 49
dwirony will become famous soon enough
Default

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.
Reply With Quote
Reply



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 Dim a substring between two strings How to link similar strings. PRA007 Word VBA 2 01-20-2016 04:22 AM
How to Dim a substring between two strings Search with multiple strings silverspr Excel 7 03-03-2013 04:45 PM
How to Dim a substring between two strings update style of all strings available between two specific strings vikrantkale Word 1 03-28-2011 06:13 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:11 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft