AutoCAD to Excel - VBA Programming Hands-On!

Name: AutoCAD to Excel - VBA Programming Hands-On!
Rating: 4.4 (70 reviews)

Your ultimate VBA Programming tutorial to Exporting AutoCAD Drawings to Excel and other formats (and Importing back).

Created byArnold Higuit

Last updated 8/2018

English

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.)

Course content

7 sections • 26 lectures • 2h 15m total length

Introduction1:06
This is the Course's Introduction Video. It will highlight the benefits of being able to export AutoCAD Drawing Data into Microsoft Excel application
Course Content4:02
This video will list out all the Course's Content
Who is this Course for?1:07
This video identifies who is this course for?
What Will I Learn from this Course?1:39
This video will identify the items that the student will learn from this course.

Exporting Line Object to Excel Introduction1:08
This video will give the user introduction on exporting AutoCAD Line Objects to Excel.
Exporting Line Objects to Excel - Hands-on Demo12:30
This video will go over the actual coding of Exporting Line to Excel program.
Exporting MText Objects to Excel Introduction0:36
This video will give an introduction of Exporting MText Objects to Excel.
Exporting MText Objects to Excel - Hands-on Demo7:43
Exporting Attribute Blocks to Excel Introduction1:23
This video will provide the user with introduction on how to export Attribute Blocks to Excel.
Exporting Attribute Block Objects to Excel - Hands-on Demo15:22
This video will continue building upon the projects and start coding for exporting Attribute Block to Excel.

Exporting LWPolyline to CSV File Introduction1:59
This tutorial will provide the user introduction how to Export AutoCAD Objects data to CSV and Pipe delimited Files.
Exporting LWPolyline Objects to a CSV File - Hands-on Demo (Part 1)3:30
This is the first part of Exporting LWPolylines to a CSV File. This tutorial will walk through the UI Design.
Exporting LWPolyline Objects to a CSV File - Hands-on Demo (Part 2)19:20
This will continue from the previous video where most of the coding will be completed to export LWPolylines to a CSV file.
Exporting LWPolyline to a Pipe Delimited File Introduction0:47
This video will give the user introduction on Exporting LWPolyline Object to a Pipe Delimited file.
Exporting LWPolyline to a Pipe Delimited File - Hands-On Demo2:16
This tutorial will show the user how to utilize the existing code and just select the Pipe as a delimiter.

Importing Line Objects into AutoCAD Introduction0:44
This video will give the user the introduction on how to import Excel File into AutoCAD.
Clear Line Objects for Importing Excel Spreadsheet - Hands-On Demo1:23
This video will prepare AutoCAD drawing for importing of Line Spreadsheet by deleting all the Lines in the drawing.
Importing Line Objects Spreadsheet File into AutoCAD - Hands-On Demo13:41
This video will show the student how to develop the program to import Line Objects from an Excel Spreadsheet file into AutoCAD.
Importing MText Objects Excel Spreadsheet File into AutoCAD Introduction0:44
This video will provide the student introduction on how to import MText Spreadsheet file into AutoCAD.
Importing MText Objects Excel Spreadsheet File into AutoCAD - Hands - On Demo8:36
This tutorial will show you how to Import MText stored in a Spreadsheet file.

Importing CSV File into AutoCAD Introduction1:03
This video will give you an overview of importing CSV or Pipe Delimited File into AutoCAD.
Importing CSV File into AutoCAD - Hands-On (Part 1)2:55
This tutorial will give you the overview of importing CSV File. This will also walk you through the UI Design as well as prepare the AutoCAD Drawing for importing by deleting the existing LWPolyline objects.
Importing CSV File into AutoCAD - Hands-On (Part 2)17:51
This is a continuation of the previous video and will walk you through the coding of importing CSV file into AutoCAD.
Importing Pipe Delimited File into AutoCAD - Hands-On4:13
This video will walk you through importing Pipe Delimited file into AutoCAD as well as adding some validation in the code.

Requirements

Knowledge of AutoCAD is required. Basic knowledge of VBA would be helpful.

Description

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.

Who this course is for:

All AutoCAD Users who want to learn how to interface AutoCAD and Excel Applications such as:
Engineers Quantity Surveyors Architects CAD Designers
All AutoCAD Users who want to learn VBA Programming
Notes: Although not required, it will help if you have a basic knowledge of AutoCAD VBA Programming.

AutoCAD to Excel - VBA Programming Hands-On!

What you'll learn

Explore related topics

Course content

Introduction4 lectures • 8min

Exporting AutoCAD Objects to Excel6 lectures • 39min

AutoCAD to Excel Extractor Project1 lecture • 9min

Exporting AutoCAD Objects to Delimited Files5 lectures • 28min

Importing Excel File Into AutoCAD5 lectures • 25min

Importing CSV and Pipe Delimited Files into AutoCAD4 lectures • 26min

Conclusion1 lecture • 1min

Requirements

Description

Who this course is for: