using .scr files in autocad from excel vba

This used to get dimensions of sections to workout centreline geometry. Will need to modify path in subroutine GrabFrameParam, to point to location of struMtrl.mdb. This is just another component towards that end. The more that can be confirmed between sales person and potential customer the more likely sale will take place. AViCAD supports every important AutoCAD file type, including AutoCAD drawings (from 2.5 through 2020), AutoCAD menus (.MNU), AutoCAD scripts (.SCR), AutoCAD. How to use of Microsoft Excel or any other spreadsheet program to create Script files How to create layers. The idea is that AutoCAD and similar are far too expensive to use as graphics engines, and also far too complex for use by sales people at point of sale, for simple structures, which can be defined by a few simple parameters and with drawings automatically generated, along with structural calculations.Īt point-of-sale need to be able to generate simple sketches, size structural components and cost the materials, in a very short time frame: about 5 to 10 minutes. To change between building elevations, and the framing plan or footing plan, modify the vba code in write_script. The macro MainApplication will generate the drawings. Also needs some work on reference coordinates: in AutoCAD I can go negative. Drag and drop the SCR file into the AutoCAD model view window.

After the first line, add the X, Y, Z coordinate list of the points. Due to lack of modelspace/paperspace and lack of layers, currently just fudged into Excel. Open it in a text editor such as Notepad. Write coordinates in an Excel file Save as file into. Basically took Excel/vba code used to generate AutoCAD script files (*.scr) and modified main library to draw using Excel Shapes instead. Among them using AutoLISP, VBA, SCR and others.On this occasion we will discuss. Experiments with Excel shapes layer, using vba.

Using .scr files in autocad from excel vba