Converting ListBox items (with multiple columns) to an existing table in word

This is part of an Excel VBA automation. I have a Pre-formatted table of 5 columns having only the header row and one empty row. Need help to fill this table using a listbox items.

The Sr No to be filled using ListItem Index
Next three table columns will be picked from ListBox Item – having 3 Columns
The last table column will be a calculated column

The number of rows should get added depending on Listbox ListCount.
Please see attached a sample word doc. I am not familiar with handling Word in VBA. Kindly help.

If you do not attach some sample 'xls' file to show what the data source (for the table in Word) looks like, then probably no one will take care of it (and the matter is not difficult at all).
Data should not be true, protect your privacy and sensitive data ... etc. ...

I indeed got good support from this forum. And I am very much thankful for that. I am working on a couple of projects with tight deadlines, hence I end up asking many questions here.

Yes the solution was simple. I read a few articles, one of them was from Paul. Below was the simple code that was used by me.
I had two doubts:
1. How to identify the right table in the word doc: by testing out a sample file with few tables, and randomly creating new tables in between I figured that the Table index is just the order in which it appears in the doc.
2. How to refer to word table cells , find existing no of rows and insert rows: I figured that from Paul's article. By the way I did that before I came back to forum to see that Paul had replied. Paul I did spend 1.5 hours reading on net to understand Word Tables.

Thank you once again for your support.

Please Login or Register  to view this content.