Produce complex AutoCAD drawings using Excel VBA
HTML-код
- Опубликовано: 14 окт 2024
- Purpose of this video is to show the production of AutoCAD drawing completely from scratch using Excel VBA. The program not only creates drawing but also creates bill of materials, material cut-list, quotation and purchase orders for the required materials but for the purpose of this video, I will be only covering the drawing part. I will release another video to show the remaining parts.
In the below shared folder I have shared a sample project showing all the necessary steps to develop the drawing using Excel.
For more information please contact us at Info@EccentricESS.com.
drive.google.c...
you have to write a Vba code in excel and autocad drawing will generate. search for insertion of block by Mr Christos. he is genius n not only uploading videos but he sharing the codes with excel and autocad.
Do you have link?
@S Mahamuni Canada
Please conduct a tutorial series so that we can learn the basic fundamentals of connecting excel vba to autocad.Thanking you.
Do you have an puclicaded article abous this topic ? Its very nice
hello. i am korean, i saw your video. very impressive. I want to make like that system. first what i should learn ? could you give me tip. I want to make my routine work into auto. thank u in advance.
Crazy Thing! I wish i could do that..
I need to implement same in my project can you pls help? But not required this much of lengthy program to my project
Thank you everyone for your feedback, I am glad that you are finding this video useful. Since most of you would like to learn the basic fundamentals of the process so I have created a sample project that can help you to get it started. Please have look at the video description for the link to the shared project (adding here as well) and let me know if you have more questions.
drive.google.com/drive/folders/1NoDFW8qgrRohnRSsWsgTFoBDsw6izreA
Can you pls share autocad vba programming basic knowledge websites or books or training 🙏
I'm trying to follow what you did, but the excels file in the drive isn't the same! Could you share with me the excel file?
HI, Mr. Sunil I would like to learn from you. is it possible for you to give training
Please contact me at Sunil.Singnapure@gmail.com
Can you pls help for me also?
Is it possible to use vlookup from excel to.autocad
Brillant piece of work
hiii sunil ji , this sheet is good indeed, can you share the details about programming . or is this sheet for sate purpose.
Hi Sumit, This is a project I am making for one of my client to show how complex AutoCAD-Excel integration can be. Please let me know what specific question you have about the programming?
I have two problems right now.
1. I have canal survey data in excel, from which i want to plot L-section, initial and final shape in Cross section at regular intervals in autocad, i have searched on net for that and have got some information but am not able to plot the initial and final shapes of cross section simultaneously with dimensions(level and distance for both shapes) marked intact.
2. I need to build a estimation sheet in which the selected rows containing description, rates etc from a schedule of rate sheet get transferred to another workbook and there the quantity can be manually entered against each item to get the estimate prepared. the problem is easy to solve with lookup function but when the lookup value goes to iteration level (e.g item no: 10.1.11 (a)(ii)) the things get messy and are uncontrollable so i am working on a VB prog to select the rows containing data and transfer to other new workbook
Thanks in advance if you could help or guide me :-)
I believe you are trying to achieve it via VBA?? Please share sample or working copy so I can see where you are getting stuck.
can I have your email id please
Sunil.Singnapure@gmail.com
is it possible to share this sheet?
suppose I have a network of lines in auto cad is it possible to extract their length to excel? thanks :)
I am sorry buddy, this is not a free copy but I can help you to build the program you like to. Yes, it is possible to extract the line length in excel.
I know how to get length of lines in Excel.(00923157668400)
Good afternoon Sunil, I see that at the beginning of your video you stated that this can also be manipulated to create a Bill of Materials list, do you think you can show us or give us the link the to video? I am working on a similar project and this video is setting me up in the right path but if i would be able to see the bill of materials video, this would be of immense help. Thank you in advance!
I am glad that this video is helpful to you. I don't have the video for that part yet, I will share it as soon as I create it.
Sunil, sounds perfect. Do you think you could share a link to somewhat instruct on how to do something similar to what you did? Thank you!
Briiliant!
I am in the same field of manufacturing of doors
Share the AutoCAD VBA
Can we use autocad visual basic for draw from Excel data??????
Yes, you can.
Thanks.
Please write down the steps for me so I can copy and repeat the step for myself.
myengineeringworld.net/2014/03/add-text-in-autocad-using-excel-vba.html#VBA_code
I learnt more from the above link
Please share the source code. or teach us maybe.
sir how to strch a line using vba
Can you share your excel sheet
Arun Nath you have to write a Vba code in excel and autocad drawing will generate. search for insertion of block by Mr Christos. he is genius n not only uploading videos but he sharing the codes with excel and autocad.
how much cost this project?
Please contact at my personal email address sunil.singnapure@gmail.com and I will be able to respond as per your requirements.
Thanks.
ok i send
Hello can send me test mail