Welcome to the SRP Forum! Please refer to the SRP Forum FAQ post if you have any questions regarding how the forum works.
Using OLE Automation to read / write to Excel / Word
Hi
After upgrading to OI 10.2 and Frameworks 16.04, the DDE functions isn't working anymore.
I have to migrate using OLE Automation.
Anyone has the programmer's refence / documentation for this ?
Thank you
Albert
After upgrading to OI 10.2 and Frameworks 16.04, the DDE functions isn't working anymore.
I have to migrate using OLE Automation.
Anyone has the programmer's refence / documentation for this ?
Thank you
Albert
Comments
This thread includes OLE automation code that works with Word documents. The principles for working with Excel are the same. Here is a link to the Microsoft OLE Automation page for Excel.
However, if you would rather not reinvent the wheel, we have a service module solution (Excel_Services) that we have already used at several sites. It makes it relatively easy to work with Excel documents because we abstract the commonly used low-level code into services so your implementation code is much cleaner (and safer). Just shoot me an email to discuss further.