Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 06-18-2012, 07:15 AM
krishnaoptif krishnaoptif is offline How to Replace Excel Cell Value in MS word by VBA.... Windows XP How to Replace Excel Cell Value in MS word by VBA.... Office 2007
Novice
How to Replace Excel Cell Value in MS word by VBA....
 
Join Date: May 2012
Posts: 23
krishnaoptif is on a distinguished road
Default How to Replace Excel Cell Value in MS word by VBA....

Hi Experts,



I want to replace excel cell value in ms word file.... if Excel Column A value is present in ms word document then replace word doc value with Excel Column B with sort name of Column A

As.. range A3 = Visual Basic and column B3 = VBA then will replace in ms word doc all "Visual Basic" keyword with "VBA" keyword with background yellow color in ms word..

if same word like "Visual Basic" is many times in ms word then all words replace with "VBA" word with yellow color but the first number of replaced word will be in read color back ground color in ms word file.....

Please find attached my excel macro file which i have developed ...

Pelase change the code for the same

my excel VBA password is----------------- kk

This is really urget... Pelase help me....
Attached Files
File Type: xls Macro.xls (47.0 KB, 38 views)
File Type: doc Doc1.doc (25.5 KB, 33 views)

Last edited by krishnaoptif; 06-18-2012 at 10:32 AM. Reason: Provide my excel VBA password
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I get excel to lock each value that is already in the cell l so I can add it iasdfs Excel 1 12-06-2011 12:52 PM
Can excel Replace metadata of image files? quiff Excel 0 11-23-2011 12:39 AM
Excel 2007 replace Jim WV Excel 2 07-17-2011 01:44 AM
Auto-populate an MS Word table cell with text from a diff cell? dreamrthts Word Tables 0 03-20-2009 01:49 PM
How to Replace Excel Cell Value in MS word by VBA.... paste formated text from Word to only one Excel cell heron Word 1 12-06-2005 02:37 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:05 AM.


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