Macro for editing tables. 1

MKEdits · Apr 24, 2023

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 · Apr 25, 2023

Use SetCellString and MergeCells methods of DrawingTable class

MKEdits · Apr 25, 2023

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 · Apr 25, 2023

Search the forum:

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

MKEdits · Apr 26, 2023

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 · Apr 26, 2023

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

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

Macro for editing tables. 1

MKEdits

Mechanical

Recommended for you

Little Cthulhu

Marine/Ocean

MKEdits

Mechanical

Little Cthulhu

Marine/Ocean

MKEdits

Mechanical

LWolf

Automotive

Similar threads

Part and Inventory Search

Sponsor