Modify Table values

[Ganesh_Shahane]

dear all, I want to access table on my drawing sheet and modify values in that tables.

Can someone please help with VBA code to achieve the same.

[Michael.Navara]

This is relatively easy job. 

Dim drw As DrawingDocument = ThisDoc.Document
Dim sheet As Sheet = drw.ActiveSheet
'First table on active sheet
Dim table As CustomTable = sheet.CustomTables(1)
'Put data. Values are like Excel cell address
table.Rows(1)(1).Value = "A1"
table.Rows(2)(1).Value = "A2"
table.Rows(1)(2).Value = "B1"

[Gshahane01]

Thank you..  there is one table with embedded excel spreadsheet. How to modify the values in it.

[Michael.Navara]

Try to modify underlying spreadsheet.

[Gshahane01]

Could you please suggest VBA code for same how to first get to that table by name and then modify underlying table. Refer attached screenshot, the tables are listed under 3rd party.

[Michael.Navara]

Embeded Excel spreadsheets are OLE objects and it is hard to edit them. This object can't be used as source for CustomTable.

I have no sample for it. Sorry.