to access an excel OLE worksheet with autolisp

[ederson_ambrosio]

Dear;
How do I access an excel spreadsheet pasted as OLE object in AutoCAD through lisp? I have looked at the activex properties of the OLE object, but I have not found how to point the spreadsheet. I need a string to fill in the code line below!

(setq plan (vlax-invoke-method wb-collection "open" "c: \\ WheretheWorksht.OLE.xls, OhMyGod?"))

Someone help?

Grateful;
Ederson

[Tom Beauford]

Gotta ask why would anyone ever insert an excel spreadsheet as OLE object instead of a table in AutoCAD?

[ederson_ambrosio]

It is a good question. But the designs are ready and there are many and contains data that need to be extracted from there!
For the time being, I directed a designer to open the drawings and open the OLE and copy and paste them as AutoCAD tables.
When it's ready I put my lisp to rotate ...
Thank you!