excel data to word table
 

I am try to create labels (not mailing, just a table with formatted
data) in Word (2000/2).

The data currently exists in excel.

It is possible to use vba to manipulate the data and write to a table
in Word?

The excel file will have 5-7 columns and an unlimited qty of rows. I
am very strong with Excel & Access vba but I have never tried to write
from excel to word.

1) is this possible?
2) can you give me a direction as to how to write & format the word
table from excel VBA?

If this can't be done it is ok, I'll likely just find a way to format
in Excel but Word is nicer if I can get the data there.

Thanks,
Tom

excel data to word table
 

You can copy a range from Excel and paste it into Word as a table.
Or PasteSpecial in various formats.

Whilst a recorded macro will not give you the code across apps, the first
step recorded in Excel and the second in Word will show you what you need to
achieve in the combined version.

NickHK


groups.com...
I am try to create labels (not mailing, just a table with formatted
data) in Word (2000/2).

The data currently exists in excel.

It is possible to use vba to manipulate the data and write to a table
in Word?

The excel file will have 5-7 columns and an unlimited qty of rows. I
am very strong with Excel & Access vba but I have never tried to write
from excel to word.

1) is this possible?
2) can you give me a direction as to how to write & format the word
table from excel VBA?

If this can't be done it is ok, I'll likely just find a way to format
in Excel but Word is nicer if I can get the data there.

Thanks,
Tom