Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Word VBA

LinkBack Thread Tools Display Modes
Old 07-05-2010, 10:41 PM
velohead velohead is offline Windows XP Office 2003
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....

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

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 11:03 AM.

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