I have been trying to work with Excel using Visual LISP, but my attempts have been pretty poor so far...
I cannot seem to get the "Item" method to work at all - I am trying to activate a specific Worksheet within a specific Workbook, (without the need to cycle through all the objects in a collection).
I have tried something like this, but keep getting "Error: Member not Found.":
(setq xlApp (vlax-get-or-create-object "Excel.Application"))
(setq Sht (vlax-invoke
(vlax-get-property
(vlax-invoke
(vlax-get-property xlApp 'Workbooks)
"Add")
'Sheets)
'Item "Sheet1"))
Any help is appreciated.