Tutorialspoint
Subscription Includes
 02:16:00 of High Quality Videos
 26  Lectures
 Full Lifetime Access
 Certificate on Completion
$ 44.99   9.73

AutoCAD to Excel - VBA Programming Hands-On!

Created by Arnold Higuit, Last Updated 31-Jul-2020, Language:English

AutoCAD to Excel - VBA Programming Hands-On!

You will learn and understand how AutoCAD interacts with Excel

Created by Arnold Higuit, Last Updated 31-Jul-2020, Language:English

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.

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

Course Content

  • Introduction

    4 Lectures 00:08:10

    • Introduction

      Preview
      00:01:06

    • Course Content

      Preview
      00:04:02

    • Who is this course for?

      00:01:23

    • What will you learn from this course?

      00:01:39

  • Exporting AutoCAD Objects to Excel

    6 Lectures 00:38:42

    • Exporting Line Object to Excel overview

      Preview
      00:01:08

    • Exporting Line Objects to Excel - Hands-on Demo

      00:12:30

    • Exporting MText Objects to Excel overview

      00:00:36

    • Exporting MText Objects to Excel - Hands-on Demo

      00:07:43

    • Exporting Attribute Blocks to Excel overview

      Preview
      00:01:23

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

      00:15:22

  • AutoCAD to Excel Extractor Project

    1 Lectures 00:09:09

    • Developing the Extractor Program

      00:09:09

  • Exporting AutoCAD Objects to Delimited Files

    5 Lectures 00:27:52

    • Exporting LWPolyline to CSV File Introduction

      Preview
      00:01:59

    • Exporting LWPolyline Objects to a CSV File - Hands-on Demo (Part 1)

      00:03:30

    • Exporting LWPolyline Objects to a CSV File - Hands-on Demo (Part 2)

      00:19:20

    • Exporting LWPolyline to a Pipe Delimited File Introduction

      00:00:47

    • Exporting LWPolyline to a Pipe Delimited File - Hands-On Demo

      00:02:16

  • Importing Excel File Into AutoCAD

    5 Lectures 00:25:08

    • Importing Line Objects into AutoCAD Introduction

      00:00:44

    • Clear Line Objects for Importing Excel Spreadsheet - Hands-On Demo

      00:01:23

    • Importing Line Objects Spreadsheet File into AutoCAD - Hands-On Demo

      00:13:41

    • Importing MText Objects Excel Spreadsheet File into AutoCAD overview

      00:00:44

    • Importing MText Objects Excel Spreadsheet File into AutoCAD - Hands - On Demo

      00:08:36

  • Importing CSV and Pipe Delimited Files into AutoCAD

    4 Lectures 00:26:02

    • Importing CSV File into AutoCAD overview

      00:01:03

    • Importing CSV File into AutoCAD - Hands-On (Part 1)

      00:02:55

    • Importing CSV File into AutoCAD - Hands-On (Part 2)

      00:17:51

    • Importing Pipe Delimited File into AutoCAD - Hands-On

      00:04:13

  • Conclusion

    1 Lectures 00:00:57

    • Conclusion

      00:00:57

Arnold Higuit

Sr. Software Developer

A Sr. Software Developer and a Microsoft Certified Solutions Developer (MCSD) and Microsoft Certified Applications Developer (MCAD) with extensive knowledge on different technology in different industries.

I have worked on several companies ranging from Architectural, Engineering & Construction, Utilities, Marketing, Telecommunications, and now in Financial Corporation.

I have been exposed to many different Technologies and Frameworks and Programming Languages. Developing applications using C#, Java, AutoLISP, VB/VBA, GIS and CAD Applications. I also worked on many different Enterprise Databases (e.g. SQL Server, Oracle, Sybase).

More Courses from Arnold Higuit