• Industries
  • Products
  • Buy
  • Services & Support
  • Communities
  • Discussion Groups

    .NET

    Reply
    Contributor
    Posts: 22
    Registered: ‎09-14-2006

    Open Linked OLE Spreadseet

    142 Views, 2 Replies
    03-21-2012 09:23 AM

    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?

    Please use plain text.
    Active Contributor
    RobRaminsh88
    Posts: 26
    Registered: ‎02-07-2012

    Re: Open Linked OLE Spreadseet

    05-09-2012 11:42 AM in reply to: davidcpreston

    I AM HAVING THE SAME ISSUES.....

     

    Please use plain text.
    Contributor
    Posts: 22
    Registered: ‎09-14-2006

    Re: Open Linked OLE Spreadseet

    05-09-2012 11:58 PM in reply to: RobRaminsh88

    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)

    Please use plain text.