I have been looking all day long and still haven't found a clear way to get the actual gauge as a custom property instead of just the thickness property. I was just wondering if anyone had a good idea? Whether it be through a design table or linking it to the gauge table or some sort of API. I am about to give up on this one.
I would like to be able to get a custom property that shows the sheet metal gauge of the part. Right now I have a thickness custom property that shows a decimal thickness of the part. I thought that there might be a way to use my gauge table that links the thickness property(in decimals) to the column that lists the actual gauges (7ga, 10ga, 22ga, etc.). The end result for what I want to do is be able to link a note to a part and it will show the gauge (7GA) instead of the thickness (0.1875).
You have to access the sheet metal gage table to do this. You will need a macro
cannot get bend table k factor
Jason
Could you please explain what that macro does or where to insert it? I am a little familiar in Excel VBA but this SolidWorks coding seems like a different planet to me.
The code goes into a solidworks macro (the code is for a .net environment). You could duplicate the code in Solidworks VBA if you want. Essentially you will tie this to a button. When the button is pressed:
I have mine running in a 'listener' dll that is constantly waiting for me to update my sheet metal thickness, so this happens automatically, but that's a story for a different thread
Jason
That seems to be what I need if I can get it to work. How do you link the thickness chosen when converting to sheet metal to the thickness on the excel sheet?
Create a base flange in a new file
2015 SOLIDWORKS Help - Creating a Base Flange
Edit the Sheet-Metal1 feature that is created. Make sure the 'Use Gauge table' option is checked. Select the gage table you want
Doing so will set the available thicknesses
Select your thickness, press the green check mark and then run your macro
If you are familiar with excel, this would be pretty straightforward to do in a design table. Here isa formula that could be quickly turned to this purpose. Finding the first number larger than .... - Excel User Group
Can you please be more specific ?
Moving this thread to "sheet metal" under "modeling and assemblies" might be beneficial to you to get answers.