This is the last part in writing Delphi Excel COM Add-Ins. We just need to be a bit more customized with individual icons passed as IPictureDisp to the UI. And we need to integrate our Delphi COM Add-In to Excel’s Ribbon by implementing the IRibbonExtensibility interface. Continue reading →

The second project should offer some more interaction to the user. Delphi provides an ExcelXP and OfficeXP unit but a TCommandBarButton cannot be found. We will add this as a TOleServer descendant. The sample COM Add-In creates a custom command bar and some buttons. It handles the Click event of the buttons. Continue reading →

COM Add-Ins have become more important when Microsoft introduced the Office Fluent User Interface. But you can use COM Add-Ins to extend functionality starting with Microsoft Office 2000 and with access to the object model of its host application. They are also used to provide add-in functionality to Visual Studio. Continue reading →

Automation Add-ins can be in-process or out-of-process COM servers and implementation of IDTExtensibility2 is optional. This is what you may find on Microsoft’s Website if you’re searching information about Automation Add-Ins. It implies that every COM server can be used as an Excel Automation Add-In due to the fact that implementation of the mentioned interface is optional. Continue reading →