VBA Experiments with Excel Shapes Layer: Structural Framing Plans
 

This Excel calculation can be downloaded by ExcelCalcs subscribers.Please login or Subscribe.

Description:

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
AutoCAD
| Find on Amazon.com | Find on Amazon.co.uk | Find on Amazon.fr | Find on Amazon.de | Find on Amazon.ca |
Excel VBA
| Find on Amazon.com | Find on Amazon.co.uk | Find on Amazon.fr | Find on Amazon.de | Find on Amazon.ca |
AutoCAD Script
| Find on Amazon.com | Find on Amazon.co.uk | Find on Amazon.fr | Find on Amazon.de | Find on Amazon.ca |

Version History
Subscribe to this topic and get notified by mail about new posts Favorite to this topic Discuss this item in the forum. Check the version history to see how this calculation has changed over time. Use the Subscribe button to receive an automatic email should this calculation be updated to a higher version. Use the Favourite button so you can easily find this calculation in the future.

Submitted On:
18 Apr 2011
Submitted By:
InfoJunkie65
File Date:
18 Apr 2011
File Author:
Conrad Harrison
File Version:
1.0
File Size:
432.73 Kb
File Type:
zip
Downloads:
29
Rating:
stars/0.gifTotal Votes:0
HTML Link:
Copy code below to your web page to create link to this page:
HTML Window:
Copy code below to your web page to create a dynamic window to this download:
Like This?:
View the profile of the person who submitted this calculation and see all their other calculations hosted at ExcelCalcs.
Need Help?:
Use the comment feature below to raise any questions relating to this download. The question will be automatically emailed the author and all users subscribing to this comment thread.

Please sign in or register to add a comment.

We have 7 guests and 42 members online
Contact Us
post/emailEmail (preferred method of contact)
telephone US +1 617 5008224
telephone EU +44 113 8152220
Our Feeds
Repository RSS. Forum RSS. User Comment RSS. News RSS.