Copy and Paste From Excel To Word

Copy and Paste From Excel To Word With Macro

For example to copy, we chose the cells between A:1 and G:30 in worksheet  .

copy from excel to word

VBA codes to copy from Excel to Word :
Sub wordeaktar()
Set Word = CreateObject("Word.Application")
Word.Visible = True
Word.Selection.PasteExcelTable False, False, False
Application.CutCopyMode = False
End Sub

No comments:

Post a Comment