Create word document from data entered in excel

[smrutikanta]

Hello All,

Requirement is to run a macro based excel program which should create a word document and copy the text from excel into word and fill in the templete fields
Below are the steps which an user should perform to get the result as stated in the above statement.

1) Enter data into an excel sheet with the first row as header
2) Click on the button in the excel(Button to be created in the excel)
3) Next a user text entry box to be pop'ed up to enter some specific information and the name of the word document.
4) Click ok after entering data

From these actions the macro should be able to create a word document with the data entered in the excel.

Please let me know if any information required to avoid any ambiguity.
Your response is awaited and appreciated!

[FDibbins]

this sounds very much like a homework assignment?

[smrutikanta]

LOL
No!
It is not a homework assignment
I tried doing that through the mailmerge functionality through the word document.
But that seems to be not serving my purpose.

Hence require some VBA code/macro which will help acheive this.

[smrutikanta]

Any help will be appreciated!
Please suggest if we can atleast do this through excel?

[smrutikanta]

is it not possible in excel?