Author Topic: API of Excal macro and AutoCAD  (Read 1920 times)

0 Members and 1 Guest are viewing this topic.

heheda_7

  • Mosquito
  • Posts: 1
API of Excal macro and AutoCAD
« on: May 15, 2020, 12:17:35 AM »
Here we have a great number of autoCAD drawings and only want to extract drawing title block including drawing no., names, dates and .etc into a spreadsheet via excel vba. I have some basics on excel vba and no idea with AIP of it with autoCAD.

I have already spent a few days to search online and majority of relevance is only about how to edit AutoCAD by excel VBA, or use DATAEXTRACTION function which is still not automatized if dealing with hundreds or thousands of drawings.

Could anyone please give me some hints, samples of codes or references where i can go? What i want is to run vba in Excel.

Great thanks!

MickD

  • King Gator
  • Posts: 3513
  • (x-in)->[process]->(y-out)
Re: API of Excal macro and AutoCAD
« Reply #1 on: May 15, 2020, 01:57:01 AM »
Welcome aboard!

Do you have access to AutoCAD open the drawings for you to read? If not you will need to use ObjectDBX or accoreconsole.exe (.net) to read .dwg 'headless' (without gui cad editor).

If you have AutoCAD there are plenty of examples such as -> https://www.afralisp.net/visual-basic-for-applications/tutorials/vba-and-excel.php

hth
Forth is like the Tao: it is a Way, and is realized when followed.
Its fragility is its strength; its simplicity is its direction - Michael Ham

"First, solve the problem. Then, write the code." John Johnson