Is it possible to adjust the drawing view scale as per the size using macro?

Is it possible to adjust the drawing view scale based on the size using macro.

Example: if overall length is 3" then the drawing view scale must be 1:1, and for  8" it must be 2:3

LengthScale
Less than 5"1:1
6" - 9"2:3
10" - 17"1:2
More than 17"1:4
SolidworksApi/macros