Taul
Well-known Member
- Joined
- Oct 24, 2004
- Messages
- 767
- Office Version
- 2019
- Platform
- Windows
I'm not sure if this is the right place to post but Here goes;
I have an AutoCAD LT 2005 drawing border, such that all the information in the drawing border (Name, Date, scale, Title, drg number etc) are set as "Attributes". AutoCAD has a built in routine called "Attribute Extraction" which extracts the data and writes it to a text file (comma delimited)
I also have an Excel spreadsheet with a bit of VBA code to import the text file into Excel and thereby keep a record of all the drawings I have done. Useful when I need to filter the spreadsheet to find an old drawing to use again.
Basically, there is only one text file that is overwritten each time the Attributes are extracted from a drawing but it takes several clicks to find the “template file” and “output file” that is needed to complete the extraction routine.
Is it possible to have this take place with a single click routine from within AutoCAD or within Excel to save a great deal of button pressing?
I have read that AutoCAD has a similar system to VBA but not as sophisticated, it's called "Autolisp" but at the moment I have no knowledge of the Autolisp system.
I am hoping it is possible to use AutoLisp to send the data to a spreadsheet or use VBA to pull the data out of AutoCAD - can any one offer assistance or advice.
Paul H
I have an AutoCAD LT 2005 drawing border, such that all the information in the drawing border (Name, Date, scale, Title, drg number etc) are set as "Attributes". AutoCAD has a built in routine called "Attribute Extraction" which extracts the data and writes it to a text file (comma delimited)
I also have an Excel spreadsheet with a bit of VBA code to import the text file into Excel and thereby keep a record of all the drawings I have done. Useful when I need to filter the spreadsheet to find an old drawing to use again.
Basically, there is only one text file that is overwritten each time the Attributes are extracted from a drawing but it takes several clicks to find the “template file” and “output file” that is needed to complete the extraction routine.
Is it possible to have this take place with a single click routine from within AutoCAD or within Excel to save a great deal of button pressing?
I have read that AutoCAD has a similar system to VBA but not as sophisticated, it's called "Autolisp" but at the moment I have no knowledge of the Autolisp system.
I am hoping it is possible to use AutoLisp to send the data to a spreadsheet or use VBA to pull the data out of AutoCAD - can any one offer assistance or advice.
Paul H