VBA Excel to Word Export Formatting Issue

I am using the following code to export data from Excel into Word. I need the word document to contain only text - it currently is formatted as a table. I have tried a variety of coding, but cannot get it to work. I am very new to VBA and am sure the fix is simple so I apologize in advance if this is a stupid question. Thank you very much!

Current VBA Module

Sub export_excel_to_word()
Set obj = CreateObject("Word.Application")
obj.Visible = True
Set newObj = obj.Documents.Add
ActiveSheet.Range("A44:D144").Copy
newObj.Range.Paste
Application.CutCopyMode = False
obj.Activate
newObj.SaveAs Filename:=Application.ActiveWorkbook.Path & "" & ActiveSheet.Name
End Sub

Try it

Please Login or Register  to view this content.

Artik

Worked like a charm! I cannot thank you enough!!!