AutoCAD to Excel - VBA Programming Hands-On!

Description

This course is your ultimate tutorial that will guide you to develop VBA Programs that interacts between AutoCAD and Excel.

You will learn the following:

- How to extract LWPolyline Objects into a CSV (or a Pipe) Delimited File 

- How to import CSV (or Pipe) Delimited File into AutoCAD

- How to extract different AutoCAD Objects Properties and export them into Excel such as Lines Mtexts Attribute Blocks

- How to import Excel Spreadsheet into AutoCAD 

- How to design a User Interface (UI) and write the code behind the control 

- Lots of VBA Programming Techniques (e.g. Debugging, ErrorHandling, Conditionals, Looping, SelectionSets, etc. etc.)

What Will I Get ?

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

Requirements

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