Sunday, 03 June 2018
  0 Replies
  3.3K Visits
0
Votes
Undo
Hi everyone
I am trying to send data from excel sheet to word document.
The data is going perfectly, the only problem is when I send the data to word the aliment in word document gets messed.
Please help with my main problem of alignment.

Thanks
Shozib

This is the code which I am using.

Private Sub CommandButton2_Click()
Dim objWord As Object
Set objWord = CreateObject("Word.Application")

Sheet1.Range("F1:Q72").Copy
With objWord
.Documents.Add
.Selection.Paste
.Visible = True
End With

Set objWord = Nothing

End Sub
There are no replies made for this post yet.