LISP to extract attributes into a excel 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"
                           )
)

 

 

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

[Jim Clayton]

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.

XL2BOM.lsp

GETCELLS.lsp

GETCELLS.txt

getexcel.lsp

getexcel.txt

excelcontrol.lsp

GETVALS.lsp

ATTEXP2XL.lsp