Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How do I isolate my Excel server (automation) from other Excel instances? | Excel Discussion (Misc queries) | |||
How do i copy columns of data in notepad into excel? | Excel Discussion (Misc queries) | |||
How to embed Word document into Excel and retain sizing, formatti. | Excel Discussion (Misc queries) | |||
Refreshing Access data in Excel | Excel Discussion (Misc queries) |