You have downloaded this file 0 times in the last 24 hours, limit is 100.
Your file downloads total 0 in the last 24 hours, limit is 20.

VBA Experiments with Excel Shapes Layer: Structural Framing Plans
This location is for Registered Users Only.
Perhaps you need to login or register.


Experiments with Excel shapes layer, using vba. Basically took Excel/vba code used to generate AutoCAD script files (*.scr) and modified main library to draw using Excel Shapes instead. Due to lack of modelspace/paperspace and lack of layers, currently just fudged into Excel. Also needs some work on reference coordinates: in AutoCAD I can go negative. Anycase its a work in progress. The macro MainApplication will generate the drawings. To change between building elevations, and the framing plan or footing plan, modify the vba code in write_script. The idea is that AutoCAD and similar are far too expensive to use as graphics engines, and also far too complex for use by sales people at point of sale, for simple structures, which can be defined by a few simple parameters and with drawings automatically generated, along with structural calculations. At point-of-sale need to be able to generate simple sketches, size structural components and cost the materials, in a very short time frame: about 5 to 10 minutes. The more that can be confirmed between sales person and potential customer the more likely sale will take place. This is just another component towards that end. Will need to modify path in subroutine GrabFrameParam, to point to location of struMtrl.mdb. This used to get dimensions of sections to workout centreline geometry.

Calculation Reference
Excel VBA
AutoCAD Script

Submitted By:
Conrad Harrison (InfoJunkie65)
Submitted On:
18 Apr 2011
File Size:
432.73 Kb
File Version:
File Author:
Conrad Harrison
Total Votes:0
Be the first to comment! Please sign in or register.

We have 157 guests and one member online

Contact Us
post/emailEmail (preferred method of contact)
telephone US +1 617 5008224
telephone EU +44 113 8152220
Our Feeds
Repository RSS. News RSS.