Hi,
Is it possible to separate the feet and inches values and put them in the BOM in separate columns? in that case how do I do it?
I have been looking all over the place and couldn't find a answer to that. I have also been going thru the Solidworks Bible and some other literature..
This is an example of what I have in mind.
| Feet & Inches | Length | Length |
|---|---|---|
| FT. | IN. | |
| 6' - 10" | 6 | 10 |
I now that this is possible to do with AutoCAD with no bigger adjustments,
//Mat
*Edit
The process should be automated
Ok, thanks Daen for your answer! It helped me alot, do you have the pure macro/VBA-code aswell? because I cannot figure out how to get my code working..
I'll get a Syntax error from your code aswell:
= "Part.Extension.CustomPropertyManager" ( "Part.ConfigurationManager.ActiveConfiguration.Name" ) ".set"
( "Leng" "&" "th_Inches" , int ( "Length@Weldment Path Sketch" - Int ( "Length@Weldment Path Sketch" / 12 ) * 12 ) )
= "Part.Extension.CustomPropertyManager" ( "Part.ConfigurationManager.ActiveConfiguration.Name" ) ".set"
( "Leng" "&" "th_Feet" , Int ( "Length@Weldment Path Sketch" / 12 ) )
Thanks in Advance
//Mattias
Mattias,
Have been away from the office...
I only created this code in the equation area. I did not create a macro version.
I can not tell from your post but make sure you have a dummy variable on the left side of the = sign. In my example I have "val1" and "val2". The names are irrelevant, but some variable has to be there.
I also notice in your code has quotation marks in places they should not be. My original equations are as follows:
"Val1"= Part.Extension.CustomPropertyManager(Part.ConfigurationManager.ActiveConfiguration.Name).set("Leng" & "th_Feet",Int("Length@Weldment Path Sketch"/12)) "Val2"= Part.Extension.CustomPropertyManager(Part.ConfigurationManager.ActiveConfiguration.Name).set("Leng" & "th_Inches",int("Length@Weldment Path Sketch" - Int("Length@Weldment Path Sketch"/12)*12))
Daen
Thanks for your reply Daen,
I realized that in SolidWorks 2012 they changed the equations.. the VBA coding will not work in the equations, therefor I got the syntax error.
But I solved this problem, instead of having the VBA-based equations i simply used your "value-equations" (the convertion equation) and some global variables. I do not know why they changed the equationmanager.. But everything works fine know so thanks for your help Daen! I appriciate it!
Mattias
Mattias,
The BOM table is limited in the math functions it allows. One method might be to calculate the feet and inches in the part file and assign these to custom properties. This can be done with some VBA in some equations. You can then point your BOM columns to the custom properties.
Attached is a rough sample (SW2011). The part has three configurations with different lengths. Each configuration has configuration specific custom properties of Length_Total, Length_Feet, and Length_Inches. A couple of equations split up the total length into the feet and inches equations and then assign these to the configuration specific custom properties.
I am just getting started in the VBA in Equations area so if you use this approach, make sure the equation examples are robust.
Daen