Data : From Excel to AutoCAD

About: Interested in Computer aided automation things

Intro: 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.

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



    • Tiny Home Contest

      Tiny Home Contest
    • Audio Contest 2018

      Audio Contest 2018
    • Fix It! Contest

      Fix It! Contest