I wonder if somebody could help me please. I have searched the internet and forums for a solution but have drawn a blank.
I have a lot of AutoCAD files which have embedded OLE objects (excel) inside. I want to be able to export only the text from the Excel OLE object using VBA (or Lisp, I don't mind which) without having to fire up the OLE application (i.e. Excel). Does anyone if it is possible to do this?
The embedded OLE objects have no link to any external files - so I imagine it must all be held somehow inside the AutoCAD file, but have no idea if or how it can be accessed?!!?
Thanks for your reply. I had also found the same post and stepped through the code. It managed to fire up the OLE application and I suppose I could instantiate a loop to extract everything from all cells.
I was hoping to avoid having to open the OLE application from a debugging and speed point of view.
If I don't manage to find a solution I may have to look again at opening the OLE app, but I'm still hopeful there's a way without having to do this.