Skip to main content

Posts

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...
Post a Comment
Read more
Recent posts

How to load a program each time AutoCAD starts up

Hello friends, Finally I have some free time to continue my blogging...so I am continuing my thread on Programming a Structural Section Drafting Program in VBA for AutoCAD. Remember the questions that I raised in previous thread about program....( Here )... I am going to demonstrate the (4) th question's solution which is pretty simple but very important for newbies.... How to load a program each time AutoCAD starts up and avoid loading the program each time you restart AutoCAD. 1. Go to Tools---AutoLISP----Load Application submenu or Tools---Load Application submenu Alternatively you can use the command line appload 2. You will see a file browse dialog box asking you to locate the application file...similar to image below: 3. Now observe, Red box number 1   Note: a. The type of files you can load into AutoCAD in red box number 1 in image above. Note: b. We use file with extension .dvb for loading a VBA program file which contains our code n ...
2 comments
Read more

VBA Program for STAAD to CAD

Well hello all, The image above is the UI of my application that extracts data from Staad.Pro and places it in AutoCAD environment. Currently it supports only the hot rolled I-sections of all the libraries in Staad environment. Tools required are .... 1. Staad.Pro V8i or 2007 2. AutoCAD 2009 To use this following are the steps... In staad ----> 1. Open staad file with model of the structure... 2. Go to Tools and then use cut section for cutting a required frame line that is to be drawn in AutoCAD 3.Select All the members that are there in the newly cut view.....make sure that nothing else is selected in other views.... 4. Done now just minimize the Staad.Pro Environment In AutoCAD----> 5. After minimizing the Staad.Pro just run the STAAD2CAD utility and select the plane in which the structural members were cut i.e. XZ plane or XY plane or ZY plane.... 6. keep the scale to be 1000 if you want the natural scale 7. adjust text height, select various layers to be a...
2 comments
Read more

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...
2 comments
Read more

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...
Post a Comment
Read more

VBA to AutoCAD simple program

hello friends, was just wondering it would be gr8 to make a VB program which controls what is drawn in AutoCAD ...... hmmmm interesting.....So i went through developer help in AutoCAD and finally managed to have a basic level of AutoCAD customization and some VB coding which i like to do... So here is the pie.... 1. Tools used were: AutoCAD2010 and VBAIDE which now we need to download from Autodesk website: http://usa.autodesk.com/adsk/servlet/item?siteID=123112&id=12715668&linkID=9240618 which enables VBA in AutoCAD2010... Objectives: adding a tool menu in AutoCAD called ICS and put a button as sub menu called 'circle' which when selected will trigger the VB program and i could do some simple stuff in AutoCAD using that VB program... Firstly, how to add a menu in existing AutoCAD window.....i.e. things like File, Edit, View.......Help, Express.....and my own ICS ..... :) For this just give a simple command 'CUI' at the command prompt of the AutoCAD.... window...
1 comment
Read more

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
Post a Comment
Read more