‘Add-in Express for Office and .net’ category archive

Problems with ADXTaskPane are solved in Add-in Express for Office v.9

Recently, our mail boxes became overwhelmed with a flow of reports describing how Add-in Express panes appear outside the host application's window. This is a manifestation of how the code calling the SetParent Windows API function can be incompatible with the recent Windows API change supported by Office 2016: Microsoft introduced DPI contexts and related API functions to let you get/set the current context... Read the rest of this entry →

Add-in Express version 9 adds support for multiple monitors in Office

This story started with Windows 10 Fall Creators Update that allowed using different DPIs on different monitors. How does it affect Office extensions? DPI unaware panes/forms are bitmap-stretched by Windows when DPI changes. To avoid this, you need to get notified about the DPI change and resize the form/pane and controls on it, use a different font size, different images (optional) and the form icon... Read the rest of this entry →

Version 9.0 of Add-in Express for Office is out!

Long-term customers of Add-in Express know that we usually sim-ship new releases with new versions of Microsoft Office. This time is different. While Microsoft guys are probably still working on the new features of Office 2019, the new major version of Add-in Express for Office and .net is live already... Read the rest of this entry →

Range.Replace() problems in all Excel versions

Range.Replace() and supposedly Range.Find() may work incorrectly in a scenario we describe on the Excel for Developers forum. A workaround is: change Range.Value directly... Read the rest of this entry →

Add-in Express for Office issues on multiple monitors with different DPI settings

Microsoft has published Office 2016 build 8828.2010 through its Office Insider update channel. That build supports multiple monitors with different DPI settings; the support relies on the API changes provided by Windows 10 Creators Update.... Read the rest of this entry →

Excel 2016 crashes if COM add-in creates a command bar control in a built-in context menu

Today's blog is about a recent crash reported by our customer. Our research shows that the crash occurs if your VSTO add-in or COM add-in creates a command bar control on a built-in context menu. We reproduce the crash when customizing the Cells context menu in this way... Read the rest of this entry →

Updating Office COM add-ins automatically

To test the example described below, download and run the application installing the sample COM add-in. When the add-in is installed, you start Excel 2000 - 2016 and find the add-in in the UI. Leave Excel open and in a couple of minutes, you'll get a notification suggesting installing an update... Read the rest of this entry →

Add-in Express supports Visual Studio 2017 Release

A couple of days ago, we published a new minor version of Add-in Express for Office and .NET that fully supports the newly released Visual Studio 2017. Now you can use any version of VS 2010 to VS 2017 to quickly create world-class extensions for all Microsoft Office versions and applications from prototype to final release... Read the rest of this entry →

How to customize MSI installer using Add-in Express ClickTwice custom actions

Let's start with the conclusion: you can deeply customize the UI and behavior of the MSI installer of your Add-in Express based Office extension using a ClickTwice custom action. To see how this works, build the project below, install the add-in by starting the MSI installer, and have a closer look at that installer's UI... Read the rest of this entry →

Localization of Office add-ins using forms-based resources

The article describes how to create a localized version of an Office add-in by using regular forms-based resources without having to apply them manually to each component, form or control... Read the rest of this entry →

Add-in Express sim-ships with Visual Studio 2017 RC

Last month Microsoft published Release Candidate of Visual Studio 2017. We, as Microsoft Visual Studio Industry Partner, were invited to support this version at the RC stage, and we were happy to seize the opportunity... Read the rest of this entry →

Introducing automatic updates for Office extensions

Version 8.3 of Add-in Express for Office and .net added support for automatic updates when using ClickTwice – MSI-based web deployment technology, this technology is closely tied with Add-in Express... Read the rest of this entry →

How to customize the appearance of advanced task panes and Outlook regions

Starting with version 8.2, Add-in Express began to open its internal infrastructure, which allows developers to customize some areas of advanced Excel, Word and PowerPoint task panes and Outlook regions. In the new release, it becomes possible to customize the header together with its controls as well as splitter and border. You can also modify the appearance of a minimized region, control the header visibility, change padding, get HitTest info and more... Read the rest of this entry →

Outlook 2016 Extensibility

The Office 2016 release is upon us and it is time we start having a closer look at the new features and changes in Outlook as well as what new extensibility the new Office 2016 platform offers to Outlook developers... Read the rest of this entry →

The Office 365 API – OneDrive / Files API

The article demonstrates how to create an Outlook add-in that integrates with OneDrive for Business and gives your users the ability to attach a file to an email directly from OneDrive... Read the rest of this entry →

Office 365 API – Querying Exchange

Today, we'll investigate how to retrieve data such as contacts, calendar entries and e-mails from Exchange. We'll create a simple Excel add-in, using our favourite Office development toolset, Add-in Express for Office and .net, which will import Exchange e-mails, contacts and calendar events into the active Excel workbook... Read the rest of this entry →

Have any questions? Ask us right now!