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.)
Goals
- 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.)
Prerequisites
- Knowledge of AutoCAD is required. Basic knowledge of VBA would be helpful.