Data : From Excel to AutoCAD

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.

Teacher Notes

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

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

Be the First to Share

    Recommendations

    • Trash to Treasure Contest

      Trash to Treasure Contest
    • Raspberry Pi Contest 2020

      Raspberry Pi Contest 2020
    • Wearables Contest

      Wearables Contest

    Discussions