Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking Excel data to Word table | Excel Discussion (Misc queries) | |||
importing Word table data into Excel - solutions for automation | Excel Programming | |||
Extract data (not in table) from Word to Excel | Excel Discussion (Misc queries) | |||
Transferring Word table data to Excel sheet | Excel Programming | |||
Data Anaylisis does not work in Embedded Excel Table in Word | Excel Programming |