how to transfer data from Excel file to Word file as per requirement

Dear experts,
Hope everybody will be in the best of your health. i have a question here.
i have data in excel format and i want to transfer it to word format. please concentrate on CNIC.
files attached.


thanks
roofi

Dear Chandra,
thank you for reply.
yes you got my question. now please give me the working how to do this. if this is copy paste or manual entry it is of no use. i need automatic formulation for the same please.

regards,
Roofi

Since you want to know how to do this, try the following macro:

Please Login or Register  to view this content.

Note: You'll need to set a VBA reference to Word, via Tools|References.

Dear Macropod,
Can you please apply your code on my attached files to make me understand better.

regards,
roofi

All you need to do is to:
• add the macro to your Excel workbook;
• set the Word library reference as described; and
• change the path in:
"C:\My Documents\Form D.docx"
to point to wherever your 'Form D' document is located.
From then on it's just a matter of running the macro.

Dear
only the one thing confusing. please make me understand the term "word library"
actually i have "winword.application". when i apply the same it returns messege
"compile error user-defined type not defined"
can you explain plz? plz check the way i applied your code in attached excel sheet.

thanks

Please read the note at the bottom of post # 5: http://www.excelforum.com/excel-prog...ml#post3672336. That tells you what to do and how to do it.