Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Word VBA

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 07-05-2010, 10:41 PM
velohead velohead is offline Windows XP Office 2003
Novice
 
Join Date: Jul 2010
Location: QLD, AUS
Posts: 6
velohead is on a distinguished road
Question General VBA Question

If I write a macro in excel, can it pass variables to Word in the following context....



Excel
copy contents of cell A1 and B1 (eg "Joe" and "Bloggs") and allocate to Variable_X and Variable_Y
open a Specific Word document
In Word....
Find [first_name] Replace with Variable_X
Find [last_name] Replace with Variable_Y

so that...
[first_name] becomes Joe
[last_name] becomes Bloggs

I presume this would be possible, provided that it is one macro ????
Is that correct ????
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
License and Activation, General... Plus, can Office 2000 read/edit Office 2003 files? Orlandes Office 9 09-24-2009 07:13 PM
One to many and many to one question Girlie4 Excel 3 08-09-2009 08:02 PM
Error: general mail failure. Quit excel restart mail system MitchellDM Outlook 1 12-19-2008 02:05 AM
Categories question & replying with attachment question glitzymama Outlook 0 03-15-2006 09:32 AM
General Options grayed out kpadgett Outlook 0 12-01-2005 08:23 AM


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


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft