You still haven't shown what the raw, unformatted data look like (ie before you've added the various tab, etc to the code and before you've done the Excel processing) , so I can't really advise on how you might go from that to the desired output. It's not even clear that you need to involve Excel at all.

Changing the table to have black cell borders is quite easy - simply use the table border tools. You might also consider applying a Table Style to the tables so that, say, the heading row has its own format.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]