Setting Design table value through Macro 1

[Vinay2479]

Hi,

I was trying to edit Design table value through macro.
I used SetEntryValue method under Designtable object.

DT.SetEntryValue(7, 3, False, cellvalue)

* DT is deisgntable object

Its giving me a compile error.
I have written the code as per syntax.
Can anyone help me on this.

Regards,
Vinay

 

[ArtemTat]

In VBA you shouldn't use the "(" and ")" symbols in the method if you do not expect the return value.

The following line is correct:

DT.SetEntryValue 7, 3, False, cellvalue

Artem Taturevich, CSWP
Software and Design Engineer
AMCBridge LLC

http://www.amcbridge.com

 

[Vinay2479]

Thanks Artem for reply.
I am not getting compile error now.
But I am not able to edit the designtable with this API.
Follwing is the bit of the code I am using,

DT.EditTable2 (True)
DT.SetEntryValue 49, 3, False, cellvalue
Doc.CloseFamilyTable

Regards,
Vinay

 

[TheTick]

Artem's previous statement is also true for your DT.EditTable2 call.

DT.EditTable2 True

You seem to be troubled a bit by VB syntax. It's one of those odd things in VB. If you are requesting a return value, you need parentheses like any other function. If not, no parentheses.

Example:

retval = DrawingDoc.SetCurrentLayer (layerName)

if you want a return value to report if the operation was successful

DrawingDoc.SetCurrentLayer layerName

Do this if you want to execute the command without a return value.

re: "void"
The word void by a command in the SW API help indicates that there is no return value, therefore you should not use parentheses to enclose arguments EVER.

Honesty may be the best policy, but insanity is a better defense.

http://www.EsoxRepublic.com

-SolidWorks API VB programming help

 

[Vinay2479]

But still I am not able to assign the value to the excel cell of design table.

Regards,
Vinay

 

[ArtemTat]

I get the disconnect from the VBA code after EditTable call? Do you have similar behaviour?

As a workaround you can use diret Excel API for editing the table.

Artem Taturevich, CSWP
Software and Design Engineer
AMCBridge LLC

http://www.amcbridge.com