Tutorialspoint

AutoCAD to Excel - VBA Programming Hands-On!

You will learn and understand how AutoCAD interacts with Excel

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

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.
Show More

Curriculum

  • Introduction
    01:06
    Preview
  • Course Content
    04:02
    Preview
  • Who is this course for?
    01:23
  • What will you learn from this course?
    01:39
Tutorialspoint
Tutorialspoint
Tutorialspoint
Tutorialspoint
Tutorialspoint
Tutorialspoint
Feedbacks
  • No Feedbacks Posted Yet..!
AutoCAD to Excel - VBA Programming Hands-On!
This Course Includes
  • 2 hours
  • 26 Lectures
  • 2 Resources
  • Completion Certificate Sample Certificate
  • Lifetime Access Yes
  • Language English
  • 30-Days Money Back Guarantee

Sample Certificate

Use your certification to make a career change or to advance in your current career. Salaries are among the highest in the world.

We have 30 Million registered users and counting who have advanced their careers with us.

X

Sample Certificate