using .scr files in autocad from excel vba

Running a script file is actually pretty easy. Once your Excel table is set up properly, simply copy and paste the “Script” column to a new Notepad file, and save it with a SCR extension (rather than a TXT) extension. I structured my Excel table such that my first column was my X value, the second my Y value, and finally my third column the AutoCAD script. Notice the spaces between each the command, and each coordinate value. In this case I chose to do the following: Knowing the command sequence of the LINE command, I can now sit down and write the framework of my AutoCAD script. Knowing that I can begin structuring my script. The “next point” prompt will continue until enter is pressed. So the LINE command prompts me for first a “start point”, and then the “next point”. I’ll admit, this seems a little elementary, but we need to be sure we know what prompts are included in the AutoCAD LINE command.

Take a look at the LINE command in AutoCAD.

But for something like this, simplicity is favored over the advanced stuff offered in the other methods. True, one could create a LISP, VBA, or even a.

My answer – get Excel to make an AutoCAD script. So the question remained, how could one make AutoCAD play connect the dots based on Excel data. Essentially the user had a couple thousand points, that he needed to draw lines between (and you thought connect the dots was only a game for kids).

Recently I received an e-mail from one of my readers inquiring about an easier way translate some raw data in Excel into AutoCAD linework. From that point pay attention to the command line prompts, and begin building your script file. Generally speaking a good place to start is by typing the command with either a “.”, “-“, or “_”. Look under the hood, and they are nothing more than an ASCII text file containing an AutoCAD command on each line.Īdmittedly as AutoCAD has progressed to a more and more graphical of an interface, it has become tougher to figure out the command line version of some commands. The power of AutoCAD script files is in their simplicity. Windows batch files carry the BAT extension, whereas an AutoCAD script file carries a SCR extension. So what is an AutoCAD script file? Quite simply a script file is a batch file for AutoCAD. Even still, the trick of yesterday can still help solve many tedious and mundane tasks today. “Back in the day” I knew of many CAD users who couldn’t go a day without running a script file or two. Script files seem to be one of the many forgotten frontiers of AutoCAD.

Using .scr files in autocad from excel vba