View Single Post
  #1   Report Post  
Adam
 
Posts: n/a
Default Automation of Excel Data to Word (ref: Galimi answers)

I have had great help with Galimi for this process (as I am still learning
VBA). I do not quite understand this code:

Sub moveToWord()
Set x = CreateObject("Word.Application")
x.Documents.Add
x.Visible = True

For Each cl In Selection

z = z & cstr(cl.value)

Next
x.Selection.TypeText CStr(z)

End Sub


What does the Z represent? Also, I need to not select everything in the
worksheet, I just need to get portion of the data. So it is not every cell.
How do I pre-define a selection?/

Thanks