AutoCAD to Excel - VBA Programming Hands-On!
- Instructor Unique
- Original
- Video Training
Learn to automate AutoCAD workflows using VBA and seamlessly export drawing data to Excel. This practical course improves productivity, accuracy, and reporting efficiency through structured programming techniques and real project examples.
AutoCAD to Excel - VBA Programming Hands-On!
Or
Take All courses for £49
1 Year Access -
Intermediate
-
32 Students
-
2 hours, 17 minutes
1 Year Access 
32 Students 
2 hours, 17 minutes Get access to 5000+ courses including this for only £49. Learn More.
Learning Outcome
- Learn and understand how AutoCAD interacts with Excel
- Understand how to extract LWPolyline Objects into a CSV (or a Pipe) Delimited File
- Learn to import CSV (or Pipe) Delimited File into AutoCAD
- Acquire the knowledge of different VBA Programming Techniques (e.g. Debugging, ErrorHandling, Conditionals, Looping, SelectionSets, etc. etc.)
- Learn to extract different AutoCAD Objects Properties and export them into Excel such as Lines Mtexts Attribute Blocks
- Learn how to import Excel Spreadsheet into AutoCAD
- Be an expert in designing a User Interface (UI) and writing the code behind the control
Overview
The AutoCAD to Excel – VBA Programming Hands-On! Course is the best way for you to gain deep insight and knowledge of this topic. You will learn from industry experts and obtain an accredited certificate after completing the course. Enrol now for a limited-time discounted price.
Like all the courses of One Education, this AutoCAD to Excel – VBA Programming Hands-On! Course is designed with the utmost attention and thorough research. All the topics are broken down into easy to understand bite-sized modules that help our learners to understand each lesson very easily.
We don’t just provide courses at One Education; we provide a rich learning experience. After purchasing a course from One Education, you get complete 1-year access with tutor support.
Our expert instructors are always available to answer all your questions and make your learning experience exquisite.
After completing the Course, you will instantly get an e-certificate that will help you get jobs in the relevant field and will enrich your CV.
If you want to learn about this topic and achieve certifications, you should consider this Course from One Education.
There are no hidden fees or exam charges. We are very upfront and clear about all the costs of the course.
Course design
The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace.
You are taught through a combination of
- Video lessons
- Online study materials
- Mock exams
- Multiple-choice assessment
Will I receive a certificate of completion?
Upon successful completion, you will qualify for the UK and internationally recognized professional qualification and you can choose to make your achievement formal by obtaining your PDF Certificate at a cost of £9 and Hard Copy Certificate for £15.
Why study this course
Whether you’re an existing practitioner or aspiring professional, this course will enhance your expertise and boost your CV with key skills and an accredited qualification attesting to your knowledge.
The AutoCAD to Excel – VBA Programming Hands-On! is open to all, with no formal entry requirements. All you need is a passion for learning, a good understanding of the English language, numeracy and IT, and to be over the age of 16.
Course Curriculum
| Unit 01: Introduction | |||
| Module 01: Introduction | 00:01:00 | ||
| Module 02: Course Content | 00:04:00 | ||
| Module 03: Who is this Course for? | 00:01:00 | ||
| Module 04: What Will I Learn from this Course? | 00:02:00 | ||
| Unit 02: Exporting AutoCAD Objects to Excel | |||
| Module 01: Exporting Line Object to Excel Introduction | 00:01:00 | ||
| Module 02: Exporting Line Objects to Excel – Hands-on Demo | 00:13:00 | ||
| Module 03: Exporting MText Objects to Excel Introduction | 00:01:00 | ||
| Module 04: Exporting MText Objects to Excel – Hands-on Demo | 00:08:00 | ||
| Module 05: Exporting Attribute Blocks to Excel Introduction | 00:01:00 | ||
| Module 06: Exporting Attribute Block Objects to Excel – Hands-on Demo | 00:15:00 | ||
| Unit 03: AutoCAD to Excel Extractor Project | |||
| Module 01: Developing the Extractor Program | 00:09:00 | ||
| Unit 04: Exporting AutoCAD Objects to Delimited Files | |||
| Module 01: Exporting LWPolyline to CSV File Introduction | 00:02:00 | ||
| Module 02: Exporting LWPolyline Objects to a CSV File – Hands-on Demo (Part 1) | 00:04:00 | ||
| Module 03: Exporting LWPolyline Objects to a CSV File – Hands-on Demo (Part 2) | 00:19:00 | ||
| Module 04: Exporting LWPolyline to a Pipe Delimited File Introduction | 00:01:00 | ||
| Module 05: Exporting LWPolyline to a Pipe Delimited File – Hands-On Demo | 00:02:00 | ||
| Unit 05: Importing Excel File Into AutoCAD | |||
| Module 01: Importing Line Objects into AutoCAD Introduction | 00:01:00 | ||
| Module 02: Clear Line Objects for Importing Excel Spreadsheet – Hands-On Demo | 00:01:00 | ||
| Module 03: Importing Line Objects Spreadsheet File into AutoCAD – Hands-On Demo | 00:14:00 | ||
| Module 04: Importing MText Objects Excel Spreadsheet File into AutoCAD Introduction | 00:01:00 | ||
| Module 05: Importing MText Objects Excel Spreadsheet File into AutoCAD – Hands – On Demo | 00:09:00 | ||
| Unit 06: Importing CSV and Pipe Delimited Files into AutoCAD | |||
| Module 01: Importing CSV File into AutoCAD Introduction | 00:01:00 | ||
| Module 02: Importing CSV File into AutoCAD – Hands-On (Part 1) | 00:03:00 | ||
| Module 03: Importing CSV File into AutoCAD – Hands-On (Part 2) | 00:18:00 | ||
| Module 04: Importing Pipe Delimited File into AutoCAD – Hands-On | 00:04:00 | ||
| Unit 07: Conclusion | |||
| Module 01: Conclusion and Thank you | 00:01:00 | ||
| Assignment | |||
| Assignment – AutoCAD to Excel – VBA Programming Hands-On! | 00:00:00 | ||
AutoCAD to Excel – VBA Programming Hands-On!