Introduction: Data : From Excel to AutoCAD

About: Interested in Computer aided automation things

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.

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

http://www.computeraidedautomation.com/article/extract-data-excel-and-use-it-autocad