Formatting a Word table with Excel VBA

Hello all,
I've spent a great deal of time in the Excel VBA forum, but I think this is more specific to members watching this one.

So far I've got the sub-routine to open a word template and paste the excel data in a table. What I cannot figure out is how to then format the table from within the excel VB editor, primarily the column widths.

When fully operational, the word document will only be created and saved without the user actually viewing it. This part is also working quite well.

The code given here is the section where the actual pasting operation runs. Hopefully this will provide enough information to let someone get me on the right path. I can upload the workbook but all of the file paths and document names would have to be changed in order for someone to test it. Thought I would try this approach first.

Thanks to any and all for suggestions.

Please Login or Register  to view this content.

Thank you for the suggestions and cleaner code.

I need to go back to the template and keep working on the formatting. This is my first go around with getting Excel and Word to work together, a lot to learn yet, obviously.

Thanks again!