AutoCAD to Excel - VBA Programming Hands-On!
Overview: Welcome to “AutoCAD to Excel – VBA Programming Hands-On!” This course is designed to equip you with the essential …
2 Students
Overview:
Learning Outcomes:
- Understand the basics of VBA programming
- Learn how to control AutoCAD from Excel using VBA
- Extract data from AutoCAD drawings and import it into Excel
- Automate repetitive tasks in AutoCAD and Excel
- Create custom commands and functions in AutoCAD
- Develop practical skills through hands-on exercises
- Gain confidence in using VBA for AutoCAD and Excel automation
- Apply learned concepts to real-world projects
What Will Make You Stand Out?
On Completion of this AutoCAD to Excel – VBA Programming Hands-On! online course, you’ll acquire:
- CPD QS Accredited Course.
- Upon Course Completion, Earn a Complimentary PDF and a hard copy Certificate to Showcase Your Enhanced Skills.
- Lifetime access.
- 24x7 Tutor Support.
- Complete the course at your own pace.
Description:
This course offers a comprehensive introduction to VBA programming for AutoCAD and Excel. It is suitable for beginners with no prior programming experience. The course is structured to provide a step-by-step guide to writing VBA code, with a focus on practical applications. Participants will learn how to automate tasks in AutoCAD and Excel, improve productivity, and create custom solutions tailored to their needs. The course includes interactive tutorials, downloadable resources, and quizzes to reinforce learning.
Who is this course for?
This course is ideal for architects, engineers, designers, and professionals who use AutoCAD and Excel in their daily work. It is also suitable for students and individuals interested in learning VBA programming for automation and productivity enhancement.
Requirements:
Basic knowledge of AutoCAD and Excel is recommended. No prior programming experience is required. Participants should have access to AutoCAD and Excel software for hands-on exercises.
Certification:
Upon successful completion of the AutoCAD to Excel – VBA Programming Hands-On! course, learners can obtain both a PDF certificate and a Hard copy certificate for completely FREE. The Hard copy certificate is available for a nominal fee of £3.99, which covers the delivery charge within the United Kingdom. Additional delivery charges may apply for orders outside the United Kingdom.
Career Path:
- CAD Technician
- Design Engineer
- Architectural Technologist
- Civil Engineer
- Mechanical Engineer
- Automation Specialist
AutoCAD to Excel – VBA Programming Hands-On! Course Reviews
An outstanding online course with clear explanations and practical examples. I could study at my own pace and still feel fully supported throughout. It’s truly boosted my confidence and career prospects
The course was well-structured, engaging, and easy to follow. The flexibility made it perfect alongside my full-time job. I’ve gained valuable, real-world skills that I can apply immediately.
Excellent learning experience from start to finish. The content was professional, up-to-date, and highly relevant. I would highly recommend it to anyone looking to upskill online.
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 | ||
Frequently Asked Questions
Yes, Discover Training provides accredited and CPD-certified courses, ensuring learners receive recognised qualifications that support career progression and professional compliance.
Anyone can enrol, including students, professionals, job seekers, career changers, and organisations. Most courses do not require previous experience, making them accessible to learners at all levels.
Discover Training offers courses across multiple sectors, including business, health and safety, compliance, leadership, IT, personal development, and professional skills training.
You will have 14 days to revoke your Course purchase from your purchase date. Regrettably, refunds are not allowed after your purchase have been approved, and materials have been posted to the student’s dashboard or accessed.
Yes, learners receive a downloadable digital certificate upon successful completion, suitable for CPD records, CVs, and professional portfolios.
-
Number of Units:
27 -
Access:
1 Year -
Duration:
2 hours, 17 minutes -
PDF Certificate
Included
