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