Introduction: Data : From Excel to AutoCAD
You can extract the data from an excel file (without opening it) and use it inside an AutoCAD file for drawing objects;
This is just an example on How to use the data from Excel Cells inside the CAD drawing to Automate the Autocad drawing process.
Teachers! Did you use this instructable in your classroom?
Add a Teacher Note to share how you incorporated it into your lesson.
Step 1: Steps
Go to VBA Editor and insert a module (Module1)
Paste following code inside (screenshot)
Save the macro as datafromexcel.dvb (or any other name you prefer with *.dvb extension)
save the drawing filecreate an Excel file (in your D drive) and enter some text/number inside cell (A:1) then save it and close.
Insert a toolbar and a button inside CAD file (refer previous articles)
link vba with button using the code ^C^C_-vbarun;Module1.clickedSet up the autoload