Hello,

I'm facing one situation.

I have customized one MS Word template for Part specifications.
I have a long list of Parts in an Excel for which I need to create Part Specifications in Word, each with it's own specification document.
I work with Excel VBA on & off but never worked with interfacing of Word & Excel.
Here's my specific requirement:
1. I Open my List of Parts in Excel
2. Run the Macro.
3. Macro Asks for the First Reference Row
4. The Macro seeks the Word template.
5. Creates a file -> New from Existing with this Template
6. Inserts Data from the Excel Reference Row to specified location in the newly created word document.
7. Performs a 'Save As' on the newly created Word Document & Renames it with specified data from the reference row in Excel.
8. Moves on to the next Row in Excel.
9. Repeats 4-8 until the range A'i' is empty.

I've been trying to work on the macro, but it's turning out to be a nightmare (I'm still a beginner) & I have to finish the list this week. I'd really appreciate the help.

Thank you,

Cheers,
Gajanan