How to update OLE graphs from Excel in documents
Posted on 2002-05-11
I'm assisting in the creation of a cross-platform presentation on CD. We choose to export from Powerpoint to HTML, but for a future 2nd project I would prefer a different way.... Domino export to HTML!
I'm writing a notes-database to provide all required functions (similar to powerpoint), but one feature is puzzling me:
Several documents (even hundreds!) contain OLE-objects (MS Excel graphs). Dominos translation to JPG and the export to images is all handled quite well, but when the charts change (e.g. colours), I'll need to update those documents.
Things work if I edit, refresh and save documents one by one, but for the expected number of documents, I would prefer an automated way. I'm even too lazy to answer "Yes" to every refresh proposal!
Has anyone got the solution (pref. LS code)?