View Single Post
 
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