How to read variables in Excel from Solid edge
How to read variables in Excel from Solid edge
(OP)
I have problem for readying a defined variable in the Solid edge in Excel.
I can not access to the variable from Vb of Excel.
For editing a variable this code for example is ok:
Call objVariables.Edit("Var_1", 0)
I want some way similar to get the value of a variable for example some function like:
Var_value= objVariables.GetValue("Var_1")
Please if you know help me.
Thank you in advance
I can not access to the variable from Vb of Excel.
For editing a variable this code for example is ok:
Call objVariables.Edit("Var_1", 0)
I want some way similar to get the value of a variable for example some function like:
Var_value= objVariables.GetValue("Var_1")
Please if you know help me.
Thank you in advance





RE: How to read variables in Excel from Solid edge
In the variable table of the Solid edge, right click on the variable then select copy link. on a sheet in an Excel file which you are running the macro right click on a cell and select paste special..., then select paste as a link.
Now you have the value of the variable in your Excel file, you are able to access to this cell by VB in macro.
RE: How to read variables in Excel from Solid edge
If u want a variable in Vb from SolidEdge just use the following
MsgBox (objVariables("aRotore").Value)
* take care angle is in radiant, distance in meter.
If u want to change a variable in SolidEdge via Excel Vb
Call objVariables.Edit("Blocco", "0")
Thanks to http:/
for great help.
r