Macro for editing tables. 1

[MKEdits]

Hello, i encountered an issue that i can't find any way to edit text in tables via VBS. For e.g i have in column "Diameter" few values but some of them are repeating for e.g 2,46 which stands for thread M4, so i want macro to search for 2,46 through this table, merge cells (cells are sorted by amount so all 2,46 would be the nearest cells) and change it for M4. Thanks in advance.

Regards,
M

 

[Little Cthulhu]

Use SetCellString and MergeCells methods of DrawingTable class

 

[MKEdits]

Could you provide any example please? It's my first macro for 2D so i would be grateful for some snippet. Thanks in advance.

Regards,
M

 

[Little Cthulhu]

Search the forum:

https://www.eng-tips.com/viewthread.cfm?qid=377858

 

[MKEdits]

I saw that macro already, but it does refer to exact cell in existing table, i wanted my macro to look for cells in one column which has the same value then merge cells and change value.

Regards,
M

 

[LWolf]

fiddle with the two commands Little Cthulhu refers to...
look at the methods for tables:

http://catiadoc.free.fr/online/interfaces/interface_DrawingTable.htm#GetCellObject

check out an example:

https://www.maruf.ca/files/caadoc/CAAScdDriUseCases/CAADriDrawingTable.htm

regards,
LWolf