AutoCAD to Excel - VBA Programming Hands-On!
You will learn and understand how AutoCAD interacts with Excel
Lectures -27
Resources -2
Duration -2 hours
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
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.
![AutoCAD to Excel - VBA Programming Hands-On! AutoCAD to Excel - VBA Programming Hands-On!](https://d3mxt5v3yxgcsr.cloudfront.net/courses/3267/course_3267_image.jpg)
Curriculum
Check out the detailed breakdown of what’s inside the course
Introduction
4 Lectures
-
Introduction 01:06 01:06
-
Course Content 04:02 04:02
-
Who is this course for? 01:23 01:23
-
What will you learn from this course? 01:39 01:39
Exporting AutoCAD Objects to Excel
6 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
AutoCAD to Excel Extractor Project
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Exporting AutoCAD Objects to Delimited Files
5 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Importing Excel File Into AutoCAD
5 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Importing CSV and Pipe Delimited Files into AutoCAD
4 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Conclusion
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Instructor Details
![Arnold Higuit](https://www.tutorialspoint.com/assets/profiles/141026/profile/200_149085-1580730457.jpg)
Arnold Higuit
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).
Course Certificate
Use your certificate to make a career change or to advance in your current career.
![sample Tutorialspoint certificate](/market/public/assets/newDesign/img/primePacks/V-certificate.png)
Our students work
with the Best
![adobe logo](/market/public/assets/newDesign/img/adobe.png)
![adp logo](/market/public/assets/newDesign/img/adp.png)
![apple logo](/market/public/assets/newDesign/img/apple.png)
![armani logo](/market/public/assets/newDesign/img/armani.jpg)
![bosch logo](/market/public/assets/newDesign/img/bosch.png)
![capegemini logo](/market/public/assets/newDesign/img/capegemini.png)
![cisco logo](/market/public/assets/newDesign/img/cisco.png)
![hdfc bank logo](/market/public/assets/newDesign/img/hdfcbank.png)
![ibm logo](/market/public/assets/newDesign/img/ibm.png)
![intel logo](/market/public/assets/newDesign/img/intel.png)
![mastercard logo](/market/public/assets/newDesign/img/mastercard.png)
![netflix logo](/market/public/assets/newDesign/img/netflix.png)
![qualcomm logo](/market/public/assets/newDesign/img/qualcomm.png)
![samsung logo](/market/public/assets/newDesign/img/samsung.png)
![sony logo](/market/public/assets/newDesign/img/sony.png)
![unilever logo](/market/public/assets/newDesign/img/unilever.png)
![walmart logo](/market/public/assets/newDesign/img/walmart.png)
![adobe logo](/market/public/assets/newDesign/img/adobe.png)
![adp logo](/market/public/assets/newDesign/img/adp.png)
![apple logo](/market/public/assets/newDesign/img/apple.png)
![armani logo](/market/public/assets/newDesign/img/armani.jpg)
![bosch logo](/market/public/assets/newDesign/img/bosch.png)
![capegemini logo](/market/public/assets/newDesign/img/capegemini.png)
![cisco logo](/market/public/assets/newDesign/img/cisco.png)
![hdfcbank logo](/market/public/assets/newDesign/img/hdfcbank.png)
![ibm logo](/market/public/assets/newDesign/img/ibm.png)
![intel logo](/market/public/assets/newDesign/img/intel.png)
![mastercard logo](/market/public/assets/newDesign/img/mastercard.png)
![netflix logo](/market/public/assets/newDesign/img/netflix.png)
![qualcomm logo](/market/public/assets/newDesign/img/qualcomm.png)
![samsung logo](/market/public/assets/newDesign/img/samsung.png)
![sony logo](/market/public/assets/newDesign/img/sony.png)
![unilever logo](/market/public/assets/newDesign/img/unilever.png)
![walmart logo](/market/public/assets/newDesign/img/walmart.png)
Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe now![Annual Membership Annual Membership](/market/public/assets/newDesign/img/membership-large-small.jpg)
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now![Online Certifications Online Certifications](/market/public/assets/newDesign/img/traning-for-a-team.png)