This page provides a collection of links to automate AutoCAD operations using EXCEL VBA.
Introduction
Do you use tools other than AutoCAD when working on something in AutoCAD or before drawing?
I do that; I often do things like come up with specifications in Excel, organize the information, have them do some calculations, and then create the blueprints in AutoCAD.
This is the main advantage of linking Excel and AutoCAD: After organizing and processing information in Excel, drawings can be generated directly from Excel. No mistakes are made by hand. Another advantage is that anyone can create drawings with the same quality, regardless of the person involved.
Click on each link to check out specific ways to work more efficiently.
INDEX
Object-based method
How to perform various operations using AutoCAD object models.
Drawing Basic Shapes
- Drawing line(s)
- Drawing circle(s)
- Drawing arc(s)
- Draw an ellipse
Advanced drawing operations
- Drawing polylines
Text and dimensioning operations
Layer Operations
- Create, delete, and activate layers
- Set layer properties
- show/hide layers
- Lock and unlock layers
Command-based method
This is a method of operating by sending commands to the AutoCAD command line.
Drawing Basic Shapes
- Drawing Rectangles
Each link details specific VBA code examples and operating procedures. Use these resources to make your work with AutoCAD easier and faster!