PDA

View Full Version : Export Excel data to Word table



Nuz
03-14-2011, 04:09 AM
I need to export data (numbers and text) from Excel sheet to a Word table. The Word table, including its layout and colour formatting has been defined already and only the data has to be exported into it.
I have to be able to modify the number formatting and the number of rows in the Word table through VBA since the table should include 1-20 rows, depending on what data there is in the Excel sheet.
I cannot find the correct syntax to set a reference to the Word table from Excel and I don't know how to add/delete rows from it. Any ideas?

mdmackillop
03-14-2011, 06:52 AM
Even formatting Tables in Word is not straightforward. This post (http://www.vbaexpress.com/forum/showthread.php?t=36364)may assist with part of your question