Tutorialspoint

AutoCAD to Excel - VBA Programming Hands-On!

You will learn and understand how AutoCAD interacts with Excel

  Arnold Higuit

   IT & Software, IT Other

  Language - English

   Published on 07/2020

0

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.
0
Course Rating
0%
0%
0%
0%
0%

    Feedbacks (0)

  • No Feedbacks Yet..!

We make use of cookies to improve our user experience. By using this website, you agree with our Cookies Policy.