Overview

This comprehensive course on Programming AutoCAD to Excel using VB.NET will deepen your understanding on this topic.

After successful completion of this course you can acquire the required skills in this sector. This Programming AutoCAD to Excel using VB.NET comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder.

How will I get my certificate?

You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate.

Who is This course for?

There is no experience or previous qualifications required for enrolment on this Programming AutoCAD to Excel using VB.NET. It is available to all students, of all academic backgrounds.

Requirements

Our Programming AutoCAD to Excel using VB.NET is fully compatible with PC’s, Mac’s, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace.

Career Path

Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to—

Open doors of opportunities
Increase your adaptability
Keep you relevant
Boost confidence

And much more!

Course Curriculum

7 sections
14 lectures
00:00:00 total length

Expand all sections

Module 01: Introduction

Introduction

00:04:00
Who is this course for?

00:02:00
What will you learn from this course?

00:05:00
Tools needed

00:01:00
Course Prerequisites

00:04:00

Module 02: Exporting AutoCAD Objects to Excel

Section Overview – Export AutoCAD Objects to Excel

00:02:00
Exporting Lines to Excel – Overview

00:02:00
Creating the VB.NET-Excel Project

00:06:00
Design of User Interface to Export Lines

00:10:00
Creating the Common Utility Class

00:19:00
Creating the ExportLines Method

00:12:00
Running and Testing ExportLines Method

00:06:00
Exporting MTexts to Excel – Overview

00:02:00
Creating the ExportMTexts Method

00:11:00
Export Polylines to Excel – Overview

00:01:00
Creating the ExportPolylines Method

00:12:00
Running and Testing ExportPoylines Method

00:12:00
Export Blocks (Without Attributes) to Excel – Overview

00:01:00
Creating the ExportBlocks Method

00:12:00
Creating Export Blocks UI and Running the Code

00:06:00
Exporting Blocks (With Attributes) to Excel – Overview

00:02:00
Creating the User Interface for exporting Blocks to Excel

00:05:00
Creation of BlocksForm UI

00:04:00
Coding the BlocksForm Load Event

00:08:00
Testing the BlocksForm UI

00:03:00
Coding the BlocksForm to populate the Listboxes

00:15:00
Coding the BlocksForm Export Button

00:04:00
Coding the ExportBlocksWithAttributes Method

00:21:00
Running and Testing ExportBlocksWithAttributes Method

00:02:00

Module 03: Importing Excel File into AutoCAD

Section Overview – Import Excel File into AutoCAD

00:01:00
Importing Lines from Excel File into AutoCAD – Overview

00:01:00
Creating ImportExcelUtil Class

00:02:00
Creating the ImportLines Method

00:19:00
Creating the UI for the ImportLines Method

00:02:00
Coding the ImportLines UI code behind.

00:07:00
Running and Testing ImportLines Method

00:08:00
Importing MTexts into AutoCAD – Overview

00:01:00
Creating the ImportMTexts Method

00:11:00
Creating ImportMTexts User Interface

00:02:00
Running and Testing ImportMTexts Method

00:02:00
Importing Polylines from Excel File into AutoCAD – Overview

00:01:00
Creating the ImportPolylines Method

00:14:00
Creating ImportPolylines User Interface

00:02:00
Running and Testing ImportPolylines Method

00:03:00
Running and Testing ImportPolylines (from a File) Method

00:02:00
Importing Blocks (without Attributes) from Excel File into AutoCAD – Overview

00:01:00
Creating the ImportBlocks Method

00:09:00
Creating the ImportBlocks User Interface

00:02:00
Running and Testing ImportBlocks Method

00:03:00
Importing Blocks (with Attirubtes) from Excel File into AutoCAD – Overview

00:02:00
Creating the ImportBlocksWithAttributes Method

00:25:00
Creating the UI for ImportBlocksWithAttributes Method

00:04:00
Running and Testing ImportBlocksWithAttributes Method

00:03:00

Module 04: Exporting AutoCAD Objects to a File

Exporting Lines to a File – Overview

00:02:00
Creating the ExportToFile Utility Class

00:04:00
Creating ExportLinesToFile Method

00:14:00
Creating the UI for ExportLinesToFile Method

00:08:00
Running and Testing ExportLinesToFile Method

00:02:00
Exporting MTexts to File – Overview

00:01:00
Creating the MTextToFile Method

00:06:00
Creating the UI for the ExportMTextToFile Method

00:01:00
Running and Testing ExportMTextToFile Method.

00:08:00
Exporting Polylines to File – Overview

00:02:00
Creating ExportPolylinesToFile Method

00:11:00
Exporting Polylines to File – User Interface

00:01:00
Running and Testing ExportPolylinesToFile Method

00:02:00
Exporting Blocks (without Attributes) to File – Overview

00:02:00
Creating the ExportBlocksToFile Method

00:10:00
Creating ExportBlocksToFile User Interface

00:02:00
Running and Testing ExportBlocksToFile Method

00:02:00
Exporting Blocks (With Attributes) to a File – Overview

00:02:00
Creating the EXportBlocksWithAttributesToFile Method

00:19:00
Creating the UI for ExportBlocksWithAttributesToFile Method

00:06:00
Coding the BlocksForm for ExportBlocksWithAttributeToFile Method

00:04:00
Running and Testing ExportBlocksWithAttributesToFile Method

00:03:00

Module 05: Importing Text File into AutoCAD

Importing Text File into AutoCAD – Overview

00:01:00
Importing Lines from a Text File into AutoCAD – Overview

00:02:00
Creating the ImportFileUtil Class

00:01:00
Creating the ImportLinesMethod

00:17:00
Creation of ImportLines User Interface

00:03:00
Coding the ImportLines UI button

00:05:00
Running and Testing the ImportLines Method

00:04:00
Importing MTexts from Text File into AutoCAD – Overview

00:02:00
Creating the ImportMTexts Method

00:09:00
Creating the TextStyle Manipulation Code

00:02:00
Creating the UI for the ImportMTexts Method

00:01:00
Running and Testing the ImportMTexts Method

00:04:00
Importing Polylines from a Text File into AutoCAD – Overview

00:02:00
Creating the ImportPolylines Method

00:18:00
Creating the ImportPolylines UI

00:02:00
Running and Testing ImportPolylines (from a File) Method

00:02:00
Importing BLocks (without Attributes) from a Text File into AutoCAD – Overview

00:02:00
Creating the ImportBlocks (without Attributes) Method

00:15:00
Creating the ImportBlocks UI

00:05:00
Running and Testing ImportBlocks (without Attributes) Method

00:04:00
Importing Blocks (with Attributes) from a Text File into AutoCAD – Overview

00:02:00
Creating the ImportBlocksWithAttributes from a File Method

00:24:00
Creating the ImportBlocksWithAttributes (from a File) UI (Part 1)

00:06:00
Creating the ImportBlocksWithAttributes (from a File) UI (Part 2)

00:04:00
Running and Testing ImportBlocksWithAttributes (from a File) Method

00:03:00