LISP to extract attributes into a excel already made

September 5, 2018

hi, my problem is that i want to get the information of a several number of Autocad files into an Excel file that i´ve already made previously(becouse in that Excel file, i have excel´s macros to work easier) , and the code that i´m going to show now, opens a new Excel and that´s what i don´t want to.

I have the excel file that i want to work with, in a route like "C:\Users\Desktop\actualiza.xlsm"

Thanks beforehand

(if (and Dwg$lst (apply 'or (apply 'append (mapcar 'cadr Dwg$Lst))))
   (progn

      (setq xlApp (vlax-get-or-create-object "Excel.Application")

                xlCells (vlax-get-property
                               (vlax-get-property
                                  (vlax-get-property
                                     (vlax-invoke-method
                                         (vlax-get-property xlApp "Workbooks")
                                          "Add"
                                     )
                                     "Sheets"
                                  )
                                  "Item" 1
                              )
                              "Cells"
                           )
)

Edited September 5, 2018 by rkmcswain
added [CODE] tags

September 5, 2018

Hello. I have a few different Excel to AutoCAD Lisps that I've collected because I spent a lot of time trying to do the same thing. I was finally able to get some help here on the forum. Maybe one of these might be of some use to you. Tks.