.NET

Reply
Contributor
davidcpreston
Posts: 23
Registered: ‎09-14-2006
Message 1 of 3 (202 Views)

Open Linked OLE Spreadseet

202 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?

Valued Contributor
RobR88
Posts: 77
Registered: ‎02-07-2012
Message 2 of 3 (165 Views)

Re: Open Linked OLE Spreadseet

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

I AM HAVING THE SAME ISSUES.....

 

Contributor
davidcpreston
Posts: 23
Registered: ‎09-14-2006
Message 3 of 3 (155 Views)

Re: Open Linked OLE Spreadseet

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

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)

Post to the Community

Have questions about Autodesk products? Ask the community.

New Post
Announcements
Are You Going To Be @ AU 2014? Feel free to drop by our AU topic post and share your plans, plug a class that you're teaching, or simply check out who else from the community might be in attendance. Ohh and don't forgot to stop by the Autodesk Help | Learn | Collaborate booths in the Exhibit Hall and meet our community team if you get a chance!