Change Thread Size from Excel
Change Thread Size from Excel
(OP)
I have a part with a single threaded hole in it. The threaded hole is created using the hole command. In expressions I create 2 user inputs (I_THREAD_DIAMETER & I_THREAD FORM). When creating a threaded hole the "hole standard" and "thread size" are both drop downs, therefore in expressions they are seen as strings. Anyway, I extract expressions to the spreadsheet. I want the user to be able to change the user inputs (I_...) and have that drive the p values (except the p98 parameters have a value of =EXPRVAL(p98")) for the threaded hole. Is this possible seeing the threads are a drop down list of values, that are created as strings? I am able to do this using a symbolic thread, but would rather complete as detailed above.
Thanks in advance.
PB
Thanks in advance.
PB





RE: Change Thread Size from Excel
Now how you might be able to drive this from a spreadsheet, you'll have to work that out, but at least you now KNOW exact which expression is actually controlling the size of the Threaded Hole.
John R. Baker, P.E.
Product 'Evangelist'
Product Engineering Software
Siemens PLM Software Inc.
Industry Sector
Cypress, CA
Siemens PLM:
UG/NX Museum:
To an Engineer, the glass is twice as big as it needs to be.