Hi all ,
I'm a complete newbie to VBA and i need some help in writing out a Macro. Macro should do the following :
Scenario: Word Document with excel object inside it .excel has two sheets

Functionality:
Macro should open the excel attachment and copy contents from certain columns and come back into Word document and paste it into a table already written

If there is already a Macro written for this or any help in which direction i should be looking for will be of great help.

I tried recording macro from word documnet but as soon as excel sheet gets opened , macro gets disabled inside excel and not sure how do v pass info between word and excel sheet !!
Thanks in advance