I am having a problem with the IF statements and was hoping someone could help me out real fast because this is probably an easy fix.
I have a design table with parts ranging from 6" diameters to 96" diameters and have a macro that creates drawings for each configuration. I am having a problem getting them to scale correctly though. I have to change the scale accordingly otherwise the smaller instances will be way too small on the drawings. The configurations are named by part number and the part number is a depiction of the size, so I was trying to use that to choose the scale, but I don't know how to use the If statements correctly I guess. I tried doing this:
IF 170000 < Number <173020 Then
Scale = 4
ElseIf 173021 < Number < 180000 Then
Scale = 8
End If
Because of the wide range of sizes, I have done like 4 or 5 of those little blocks and it will only change the scale according to the first like 5 lines, then it basically ignroes the rest. Anyone have any advice?
SolidworksApi macros