Excel interacting with Word

[techishawn]

My excel and word file is in same folder.

My excel file consists:

Name Amount
John $1
Mary $2
Gary $3
[button]

Let say I highlight John and $1 - this 2 cell and press the button, it would open up word and pass value over.
Not only these 3 entries(not hardcoded), user could add in more entries. So I have to target A1 to end, similarly for B1 to end.

My word file :

$Name
$Amount
left
I would set a default template style , $Name will be bold left align etc. For the variable it would automatically replace with "John" value from excel, similarly for Amount

I am new to macros, unsure how to add in macros, hope you can guide me too.

Thank you.

[techishawn]

Still need help on this

[macropod]

Cross-posted AND ANSWERED at: http://www.mrexcel.com/forum/excel-q...ting-word.html

Please read the Cross-Posting policy in rule #8: http://www.excelforum.com/forum-rule...rum-rules.html