Import selected cells from open excel workbook

[deheylen690271]

I'm trying to write a LISP routine where the values of an already selected ranged of cells in an already open excel workbook are iterated and read into the drawing. I have tried this:

(setq ^ExcelApp   (vlax-get-object "Excel.Application"))
(setq ^WorkBook  (vlax-get-property ^ExcelApp 'ActiveWorkBook))
(setq ^WorkSheet (vlax-get-property ^ExcelApp 'ActiveSheet))
(setq ^Selection (vlax-get-property ^ExcelApp 'Selection))

and this:

(setq ^ExcelApp   (vlax-get-object "Excel.Application"))
(setq ^WorkBook  (vlax-get-property ^ExcelApp "ActiveWorkBook"))
(setq ^WorkSheet (vlax-get-property ^ExcelApp "ActiveSheet"))
(setq ^Selection (vlax-get-property ^ExcelApp "Selection"))

In both case, the values for ^WorkBook, ^WorkSheet & ^Selection are nil.

If I run (vla-put-visible ^ExcelApp :vlax-true) after the vlax-get-object call, a second instance of excel with no workbooks open is displayed (which might explain the nil values). Can someone please show me how to capture the selected cells?

As always, any help is greatly appreciated.

[Opie]

Have you searched the AutoLISP forum for Excel examples? I am fairly certain Excel has been discussed in the past.

[BIG-AL]

Have a look at this an example excel lisp