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.
For better understanding the question, the attachment is uploaded.
The red line in Word attachment, is showing the problem.
This is the code which I am using.
Private Sub CommandButton2_Click()
Dim objWord As Object
Set objWord = CreateObject("Word.Application")
.Visible = True
Set objWord = Nothing