Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-01-2016, 01:37 AM
Aswinraj Aswinraj is offline Need Macro for Find and Replace, Inserting logo in Ms-Word. Windows 7 64bit Need Macro for Find and Replace, Inserting logo in Ms-Word. Office 2013
Novice
Need Macro for Find and Replace, Inserting logo in Ms-Word.
 
Join Date: Jun 2016
Posts: 1
Aswinraj is on a distinguished road
Post Need Macro for Find and Replace, Inserting logo in Ms-Word.

Hi Colleagues,

Need to create a Macro to find a particular word in Ms-Word and need to replace with another word.

Kindly refer the attachments..,

Once User Clicks "UPDATE ALL" Button, it should go to the Word Document and Search the "KEY WORDS" provided in 1,2,3 Columns and then those Key Words should be replaced with New Words User provided.
Customer Logo - User will be uploading the image and it also should be updated in the place where "Customer Logo" Word has been placed.

Ie., When user provided a word as "Aswinraj" in "1" and clicks update - Then the "CUSTOMER FULL NAME" word in Ms Word should be replaced.

Like that When user provided a word as "Aswinraj JOB" in "2" and clicks update - Then the "CUSTOMER FULL NAME & ACRONYM" word in Ms Word should be replaced and so on.

User should have privilege to Choose the Document to be replaced.
Attached Images
File Type: jpg Capture.JPG (32.2 KB, 20 views)
Attached Files
File Type: xlsx Word Macro.xlsx (11.0 KB, 10 views)
File Type: docx ITC.docx (19.7 KB, 9 views)
Reply With Quote
  #2  
Old 06-05-2016, 04:33 PM
macropod's Avatar
macropod macropod is offline Need Macro for Find and Replace, Inserting logo in Ms-Word. Windows 7 64bit Need Macro for Find and Replace, Inserting logo in Ms-Word. Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Using Excel for this seems to serve no useful purpose. For what you've described it would appear that a Word template with a userform, formfields or content controls would be more suitable.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Find and Replace Macro Need djpemberton Word VBA 2 05-04-2016 07:53 PM
Need Macro for Find and Replace, Inserting logo in Ms-Word. Find and Replace Macro amparete13 PowerPoint 3 03-11-2014 05:29 AM
Need Macro for Find and Replace, Inserting logo in Ms-Word. Word VBA Macro to Find and Replace based on the Alt Text of an Image bennymc Word VBA 1 01-27-2014 04:23 PM
macro or find/replace JamesVenhaus Word 2 02-27-2012 03:34 PM
Find and Replace Macro - A Better Way Tribos Word VBA 0 10-08-2008 03:22 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:31 PM.


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