Jeffery was not content to share just the block library manager. Interface with Excel (Tip #1980) provides a set of tools for interfacing AutoCAD drawings with Microsoft Excel. Visual LISP programmers interested in a nice set of examples that can be used right away as handy utilities should look at Jeffery s work. If you re just starting into the concepts of interfacing Excel with AutoCAD through Visual LISP, you can learn a great deal from these well-documented and consistently structured programs. One handy aspect of this set is the Replace Text option that searches out text objects in the drawing that are cell names in a spreadsheet, such as A1 or B12. When found, the cell name label is changed to match the value in the current spreadsheet at the same location. |