AutoCAD LT 2005

Taul

Well-known Member
Joined
Oct 24, 2004
Messages
767
Office Version
  1. 2019
Platform
  1. 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
 

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.
Thanks for the reply but Yes, the support paths just show where the support files are located, so if I had an Autolisp file to run the routine I needed, then I would know where to put the file. The files that are located in the support location do not help or indicate how to produce Autolisp files and a search on the internet only gives guidance for Autolisp files for the full version of AutoCAD, not the LT version.
What I was hoping for was some advise about which was best - run it from Excel with VBA or run it from AutoCAD with a Autolisp file, or better still has anyone come accross this before ?

Paul H
 
Upvote 0
It would appear that Autolisp (a VBA variant) has been removed from AutoCAD LT and only exists in the full version of AutoCAD. :cry:

So it's "script" files or nothing !

Thought I would post this in case someone else was looking.

Paul-H
 
Upvote 0

Forum statistics

Threads
1,224,926
Messages
6,181,793
Members
453,067
Latest member
cernytomas

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top