Hi!
I am trying to create a small VBA code (from excel) that allows me to do a new dataextraction everytime, and create an Excel file (not necessary to be linked with the drawing, i just want the file extracted).
Lets picture the situation:
I have 100 drawings that contains the information more or less in the same shape. I want to run my code once for each drawing.
I have found a solution to an extent:
Sub dataextraction()
AutoCAD.Application.ActiveDocument.SendCommand ("-dataextraction" & vbCr & "C:\Users\alvar\OneDrive\Documentos\pruebaDirectos1.dxe" & vbCr & vbCr)
End Sub
It works, but it creates an excel file with the data of the drawing which the .dxe file comes from.
What i really want is to do an extraction from scratch, but with an specific shape previously set.
Is it possible somehow? it would be very useful because i could skip the dataextraction wizard every time i do the extraction, since i have a great deal of documents.
Thank you very much
Regards
