VBA for exporting a worksheet to Word document?

[aduma]

I have the following code that allows me to open a new Word document from Excel:

Sub createnewWordDocument()
Dim msWordApp As Word.Application
Dim doc As Word.document
Dim i As Integer

Set msWordApp = CreateObject("Word.Application")
msWordApp.Visible = True

Set doc = msWordApp.Documents.Add

With doc
For i = 1 To 100
.Content.InsertAfter "test line" & i
Next i

End With

End Sub

If I wanted to insert "Worksheet1" into the Word document in table format, how would I do that?

[Cutter]

May I suggest posting your Excel related question in the Excel Programming forum instead of this Access Programming forum.
And it would be best if you add code tags around your code as per the forum rules.

[aduma]

My bad. I thought I was in the Excel Programming forum.

[Cutter]

To any mods finding this - the OP has started a new thread in Excel Programming:
http://www.excelforum.com/excel-prog...-with-vba.html