Topic: How extract atributtes to an excel file already made

[carlossebas]

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"
                           )
)

 

 

[ribarm]

https://forums.autodesk.com/t5/visual-lisp-autolisp-and-general/lisp-to-write-on-a-excel-alredy-made/m-p/8246706/highlight/true#M373694