I have managed to read the OleFrame object and get the path to the excel spreadsheet.
I can programatically open that spreasdsheet by using the Excel.Openworkbook method, update, save and close but it does not update the data in the linked OLE object in the AutoCAD drawing until I close and reopen the drawing or open the OLELINKS dialog box and select [Update Now]. It is set to automatically update.
If I right click on the Ole object and open the spreadsheet from the menu, and edit it then the changes are reflected in the Ole object in AutoCAD. I cannot see a method to open the linked object, or the equivalent of the Update Now in the API. Any ideas?
It has been reported to AutoDesk support, who have made a request for a change, but I don't know in practical terms what that means, except I don't imagine there will be a quick fix. At the end of my routine I just issue
SendStringToExecute("OLELINKS ", True, False, False)
Access a broad range of knowledge to help get the most out of your products and services.
Start with some of our most frequented solutions or visit the Installation and Licensing Forum to get help installing your software.
Upgrading to a 2015 product? Make sure to check these out 1st!