View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] tom_overstreet@hotmail.com is offline
external usenet poster
 
Posts: 1
Default 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