Sub AddNew(fname,Row)
Set NewBook = Workbooks.Add
With NewBook
.Title = "All Sales"
.Subject = "Sales"
.SaveAs Filename:=fname&".Doc" //创建名为*.Doc文件
End With
Workbooks.Open(fname&".Doc") //打开这个文件
Set oDoc = ActiveDocument
Set oTable= oDoc.Tables.Add(Range:=oDoc.Range(Start:=0, End:=0), NumRows
:=1) //创建一行
oCell.Range.InsertAfter row //写如一行
End Sub
For Counter = 1 To 20
Row=Workbooks("Book1").Sheets("Sheet1").Rows(Counter) //读Execel第一行
AddNew(Counter,Row) //调用AddNew创建Doc表以及写入数据
Next Counter