Library

Course: AutoCAD to Excel - VBA Programming Hands-On!

AutoCAD to Excel - VBA Programming Hands-On!

  • Life Time Access
  • Certificate on Completion
  • Access on Android and iOS App
About this Course

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.

Who is the Target Audience?

All AutoCAD Users who want to learn how to interface AutoCAD and Excel Applications such as:

  • Engineers
  • Quality Surveyors
  • Architects
  • CAD Designers

All AutoCAD users who want to learn VBA Programming

Basic knowledge
  • Basic knowledge of AutoCAD and Excel is required
What you will learn
  • You will learn and understand how to 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 learn how to create a Module and passing parameters to Function
  • You will learn lots of VBA Programming, Techniques ( E.g. Debugging, Error Handling, Conditionals, Looping, SelectionSets, Etc
Curriculum
Number of Lecture: 26
Total Duration: 02:15:49
Introduction
  • Introduction  

    This is the Course' Introduction Video. It will highlight the benefits of being able to export AutoCAD Drawing Data into Microsoft Excel application

  • Course Content  

    This video will list out all the Course' Content

  • Who is this course for?  

    This video will list out all the Course' Content

  • What will I learn from this Course?  

    This video will identify the items that the student will learn from this course.

Exporting AutoCAD Object to Excel
  • Exporting Line Object to Excel Introduction  

    This video will give the user introduction on exporting AutoCAD Line Objects to Excel.

  • Exporting Line Objects to Excel - Hands-on Demo  

    This video will go over the actual coding of Exporting Line to Excel program.

  • Exporting MText Objects to Excel Introduction  

    This video will give an introduction of Exporting MText Objects to Excel.

  • Exporting MText Objects to Excel - Hands-on Demo  
  • Exporting Attribute Blocks to Excel Introduction  

    This video will provide the user with introduction on how to export Attribute Blocks to Excel.

  • Exporting Attribute Block Objects to Excel - Hands-on Demo  

    Exporting Attribute Block Objects to Excel - Hands-on Demo

AutoCAD to Excel Extractor Project
  • Developing the Extractor Program  

    This tutorial will show the user the actual development of Extractor Program starting from designing the UI and creating a module to consolidate all functions.

Exporting AutoCAD Objects to Delimited Files
  • Exporting LWPolyline to CSV File Introduction  

    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)  

    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)  

    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 Introduction  

    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 Demo  

    This tutorial will show the user how to utilize the existing code and just select the Pipe as a delimiter.

Importing Excel File into AutoCAD
  • Importing Line Objects into AutoCAD Introduction  

    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 Demo  

    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 Demo  

    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 Introduction  

    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 Demo  

    This tutorial will show you how to Import MText stored in a Spreadsheet file.

Importing CSV and Pipe Delimited Files into AutoCAD
  • Importing CSV File into AutoCAD Introduction  

    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)  

    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)  

    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-On  

    This video will walk you through importing Pipe Delimited file into AutoCAD as well as adding some validation in the code.

Conclusion
  • Conclusion and Thank you!  
Reviews (0)