Deleting/removing content on Word table using Excel VBA (not Word VBA)

[ulster0709]

Hi Experts,


I have just learned vba few months ago and I have a problem that I havent been able to solve, could you help me or give me some advice please.


I am using VBA excel to copy a table from excel into a table on word (the table on word has invisible border and it is just for layout/structure purposes and facilitate navigation when using excel vba), however, before I paste the table, how can I delete/clear the content that was already present on the word table using excel vba? Below is the code where changes needed to be made.

WDApp.Activate
With WDApp
WDdoc.Tables(1).Rows(5).Select
'WDdoc.tables(1).Rows(5).Clearcontents <- it didnt work
'WDdoc.tables(1).Rows(5).delete <- it worked, but I dont know how to add a row on word table, I need this particualr row becuase it is the row to which the table from excel will be pasted
End With

Thank you

 

[Macropod]

Everything in your code in post #17, from 'With WDApp' onwards is Word VBA.

 

[ulster0709]

Thanks for clarifying. Does that mean Word VBA would also work on Excel?

If you were me, how would you adjust the code in #17 so that the table pasted would be in the centre on Word?

Thanks

 

[Macropod]

Does that mean Word VBA would also work on Excel?

If you're asking whether you can run Excel VBA code from Word, then answer is yes.

If you were me, how would you adjust the code in #17 so that the table pasted would be in the centre on Word?

I already posted code to do that way back in post #6.