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 ????
|