HELLO

I want a write a code in excel macro for

1.Create "n" new word document with column A in excel as file name

2.Inside each word file

ID Number A1,2,3,4,5..
Theme B1,2,3,4,5..
Type of article C1,2,3,4,5...
Keywords D1,2,3,4,5..
Word Count E1,2,3,4,5
Guideline link F1,2,3,4,5
Sample Link G,1,2,3,4,5

i want the file to be named as 1 and inside the file 1 the table must contain
ID Number A1
Theme B1
Type of article C1
Keywords D1
Word Count E1
Guideline link F1
Sample Link G1

in file 2 file name 2
ID Number A2
Theme B2
Type of article C2
Keywords D2
Word Count E2
Guideline link F2
Sample Link G2

these are the things that has to be in the word document

can you please help me...