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
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.