Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
2 Hour(s) 15 Minute(s)
Language
English
Taught by
Arnold Higuit
Rating
1 views
Course Overview
Your ultimate VBA Programming tutorial to Exporting AutoCAD Drawings to Excel and other formats (and Importing back).
This course will show you how easy it is to Export AutoCAD Drawing Information to Excel (and other Formats) using VBA.
We will walk through the actual development starting from User Interface design to coding the logic behind the form and explain every single line in detail. You will learn and have a good understanding of VBA Programming as we progress along the course. By the end of this course, you can be productive right away and you should be able to perform all these tasks and start building your own program or build upon the Projects that we’ve developed throughout this course.
Note 1: If you haven't installed AutoCAD VBA IDE yet, please refer to Section 2 of my other course AutoCAD VBA Programming - Beginner Course. This section is available for viewing and will walk you through the process of downloading and installation as well as have a good tour of Integrated Development Environment (IDE).
Note 2: This course dives directly into the actual process of extracting AutoCAD objects to Excel. If you are not very familiar with VBA yet, I suggest that you take my course "AutoCAD VBA Programming - Beginner Course". This course teaches you all the basics and fundamentals of using VBA which will help a lot when you start learning this AutoCAD to Excel course.
Course Content
- 7 section(s)
- 26 lecture(s)
- Section 1 Introduction
- Section 2 Exporting AutoCAD Objects to Excel
- Section 3 AutoCAD to Excel Extractor Project
- Section 4 Exporting AutoCAD Objects to Delimited Files
- Section 5 Importing Excel File Into AutoCAD
- Section 6 Importing CSV and Pipe Delimited Files into AutoCAD
- Section 7 Conclusion
What You’ll Learn
- You will learn and understand how AutoCAD interacts with Excel
- You will learn how to extract different AutoCAD Objects Properties and export them into Excel such as Lines Mtexts Attribute Blocks
- You will learn how to extract LWPolyline Objects into a CSV (or a Pipe) Delimited File
- You will learn how to import Excel Spreadsheet into AutoCAD
- You will learn how to import CSV (or Pipe) Delimited File into AutoCAD
- You will learn how to design a User Interface (UI) and write the code behind the control
- You will also learn lots of VBA Programming Techniques (e.g. Debugging, ErrorHandling, Conditionals, Looping, SelectionSets, etc. etc.)
Skills covered in this course
Reviews
-
PPablo Antonio Correa
Excellent!
-
PPetre Ionut
Thank you for this course! This course has allowed me to understand how VBA works for AutoCAD.
-
PPrzemysław Palicki
There are not files for self edition. Nothing.
-
DDavid Williamson
This is my second course with this instructor and he is excellent. He includes examples which compound the benefits of the topic of discussion by showing many practical skills simultaneously. I really appreciate that attention to detail.
