AutoCAD Excel Interface (Tip #2107) comes from Q.J. Chen of China and is the perfect answer for a topic that appeared just recently in the Hot Tip Harry forum. The purpose of this utility is to transfer text information stored in a grid layout (table) into an Excel worksheet by just locating the corners of the table. Load the LISP code and type B2E to activate the function. It will request two points representing the corners of the table (upper left and lower right). The rest is automatic. The text inside the grid is selected and sent to an Excel worksheet. This function works best when Excel is already open and running before starting the command. An animated GIF shows the operation of the function set included with the download file for this tip. The animated GIF is very interesting to watch because it shows the Chinese versions of AutoCAD and Excel. Harry picked this one as the top tip of the month right away! |