To Format the Existing Table in a Microsoft Word Document using Microsoft Excel, you need to follow the steps below:
- Create the object of Microsoft Word
- Open the already existing word document
- Make the MS Word visible
- Get the Table object
- Edit the data in table
- Save the document
Create the object of Microsoft Word
Set objWord = CreateObject(“Word.Application”)