AutoCAD 2002 and higher versions. MS Office 2000-2003

Hello,

I’ll try to explain my SCRIPT generation methode in Microsoft Excel. In the attachment, you will find an XLS file and an example lisp file. Test.xls and Purgea.lsp.

First open the “test.xls”

Fig.1

Click on yellow area! This runs the macro that create the script file.

Fig.2

Click on ‘Nee’! The text above means “Do you have a file with filenames” Nee = No

Fig.3

Click on the directory where the drawings are. In the same view find the lisp-file that you need. In my example lisp-file will purge all the drawings and set them to LAYER “0”.

Fig.4

The Excel-file makes automatically a script-file.

Fig.5

Give a file name. And after in AutoCAD via “Tools, etc…” , run your script!

The version of my Excel is 2000. It runs my macro perfect.

It takes aprx 20 mins to purge 300 drawing with my script.
At my Home I use Office 2007, and it don’t working!

The VBA of the Excel must be changed, but I don’t know how to do this?

Have a nice day.

Attached File:

• Download script-2.zip

Related Articles:

• Script Usage (To Edit Multiple Drawings Quickly)

Similar Posts

• Script Usage (To Edit Multiple Drawings Quickly)
• Customization Methods in AutoCAD.
• Loading AutoLISP applications automatically
• Protecting your AutoLISP codes
• (command…) versus (entmake…)

Rate this article:

(No Ratings Yet)

 Loading ...

Total: 2049
This week: 41
Today: 2
Last read: 25 July 2008, 4:22

Autocad, Programming