Edit Table within Word Document from Excel

[sandy1977]

Hi guys,

I need some help. I'm running some macros from a master workbook and generating a Word document with the data taken from my Excel file.
This Word document is saved in one of my "D" drive using the values from Cells(2,2) of my master Excel workbook.

So after my Word document is created and saved, I want to be able to, using VBA, edit a table that is within this Word document that I created (I have attached a sample of the Word document for practical purposes).
I want to delete all rows of the table where the first column value starts with "[[". The table looks like this:

Word Table.jpg

My limited VBA knowledge has taken me to the following code, but this is only the beginning, I don't know where to go from here, any help is appreciated.

Please Login or Register  to view this content.

Thank you in advance for any help provided.

[AlphaFrog]

Please Login or Register  to view this content.

[sandy1977]

Perfect AlphaFrog, thank you so much for your help.

[AlphaFrog]

You're welcome. Thanks for the feedback.

[sandy1977]

Hello AlphaFrog, I wanted to ask you how would the code look like if I had more than one table in my Word document, and I wanted it to scan all the tables within that Word doc.

[AlphaFrog]

Please Login or Register  to view this content.

[sandy1977]

Excellent, thank you so much...again

[sandy1977]

AlphaFrog would you happen to know why the code gets stuck when the path to the file is too long. I'm guessing that's the reason.
When I step through the code it gets stuck in this line:

Please Login or Register  to view this content.

and then it shows this message:

2017-01-16_12-02-32.png

[sandy1977]

Sorry for all the questions, but It's weird because now it's working. Don't know what changed.