excel data to word table

  • Thread starter Thread starter tom_overstreet
  • Start date Start date
T

tom_overstreet

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

display message box in excel(2003) using VBA word(2003) 0
Tranfer data from Excel to word (Docx) via VBA in Excel 5
Excel VBA in Citrix. 0
Open a word mail-merge document from Excel VBA 1
Copy to a Word Table 5
In VBA, check if file is corrupt or not Excel 5
Startup Notepad from Excel??? 13
writing excel data into word document 1

Back
Top