Steel Drawing program to aid Drafting in VBA for AutoCAD

Xmas Greets to All!!! :),

Hello there,

Hmmm, its been a good time in office doing some designs and drafting as well for some good projects. The idea came to my mind for reducing drafting time and do it a bit easier way....i developed this tiny program that helps draw plan view and front view of some common I-Beam sections in AutoCAD and i don't need to keep looking at steel table every time for looking out for values of web thickness, flange width and all.....later searching internet i came to know that there exists a much advanced program on the same idea....but we need to pay for using it....and is simply much more powered than my program...but i learnt many things while doing this one....!!!

So, here is how my program works....yuppp pal it really does :),

1. The VBA program is loaded automatically each time AutoCAD is started...
2. There is a simple GUI attached which enables user to choose the library of the steel sections.....viz Indian, British.....for now i have just loaded these two libraries...
3.The user then selects the I-beam from a drop down menu....and can assign different layers to different lines generated after drawing....viz....centre line, web thickness line, etc...
4.The user pushes a button to choose between Plan or Elevation and the GUI hides and user inputs are taken for start and end point of the steel beam inside AutoCAD Modelspace....
5. After the second point input the beam is drawn to 1:1 scale from start point to end point with lines in required layers..... :)

What i learnt while programming this one........will reveal it later on this text :)

1. How to connect to a Microsoft® Access(97-2000) database file for generating list of I-beam sections and retrieving their properties???
2. How to get user inputs for points???
3. How to get list of layers from current drawing in combo box???
4. How to load VBA project each time AutoCAD is started???
5. How to initiate the VBA program from a custom menu in AutoCAD itself...!!!

Comments

Using Excel VBA Macro to Add Numbering Bullets to Any Data

N.B.: For Code Scroll Down :) Hello Everyone, This is Sachin K here again, Today while at work one of my colleague got into a trouble. He entered a lot of data into a spreadsheet like names of person and data related to their documents in front of their name. Now all of a sudden he needs to insert a numbering bullets in various rows, similar to one can find in MS Word. Oh !!! Its not there !!! I thought I could write a simple VBA code instead and make things easy for him. Here is the situation (Screenshot 1): You have data in row as seen below from Row No. 2 to Row No. 13. You want to insert 1) , 2), 3), ..., etc. in front of each data in the same cells as they are. It easy to put serial in empty cells in front of the data but remember that's not what we want here. Screenshot 1 : The Problem Here is the Solution (Screenshot 2): The VBA Code runs and gives a result as shown in screenshot below Screenshot 2 : The Solution The VBA Code and Form used (Scree...

Getting Thumbnail of images, Pdfs and DWG files

Its very much easy to get the thumbnail of the files supporting the thumbnail view like image files, Dwg files, pdf files........many programs need such kind of thumbnails. in VBA or VB6 projects you just need to add a simple control and set the filepath and thats it it is done!!!....i explain it below.... 5 easy steps to go so be patient.... :) 1. Go to Toolbox where general controls lie like textbox, label, button etc..... 2. right click over toolbox and go to Components........... 3. Select the following type library from controls.......if its not there in list go to browse and add it from system32 folder........add webvw.dll and u ll see this control in list....... if using VBA u might have this library alreay loaded and named " thmb ctrl "........ 4. u ll see a blank white control added to your toolbox..... 5. Just put that control on the form and in the code set thumbctl1.displayFile = "path of the file" 5. you could use common dialog to get th...

Clock - My 2nd Vb6 application

This one is my 2nd application called clock. I think most of the beginners in VB or other platform surely make a clock program by curiosity and to learn more, so do I have done one. I learnt many things while programming this one. Its color changing capability is I think cool and one should give it a try n try make a great color combination. The biggest challenge while programming this one was making the border less form movable by user click and drag. I could not create logic well and coded something bizarre that was moving the form out of the screen!!! Anyways to tackle with this problem I searched a VB coding forum and found a nice code that just worked amazingly. Thanks to the person for that code and making me realize I have a long way to go and learn. Anyways, greets to all. Download From 4Shared DOWNLOAD Download free. Thank you for downloading... Sachin Kharat

My VB6/VBA Blog

Search This Blog