Export Excel data to Word table

[Nuz]

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]

Even formatting Tables in Word is not straightforward. This post may assist with part of your question