Guest looseLISPSsinkSHIPS Posted September 7, 2009 Posted September 7, 2009 Hola! We have a situation where we use varying scale sizes for particular block (template dwg) inserted into our other drawings. Depending on our user input in the custom VBA program a scale is determined and located within an excel table. This information appears in cell 2E on worksheet #2. What I'm trying to achieve at the moment is to set a variable to the value of this particular cell and then use it to set the required block (template dwg) size/ scale automatically. I know my scale contains a hash (#) so I need to Dim it as a Double. So far I got this, perhaps you might know better? ;===CODE SNIPPET STARTS HERE=== Dim FTW As Double 'Sets template insertion scale... FTW = worksheet(2).cells(5, 2).value ObjBlockRef.XScaleFactor = FTW ObjBlockRef.YScaleFactor = FTW ObjBlockRef.ZScaleFactor = FTW ;===CODE SNIPPET ENDS HERE=== Thanks- Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.