Posts Tagged ‘VB.NET’

Inner details of DPI scaling in Office COM add-ins

Today, I’m following Microsoft recommendations and using code fragments they provide to investigate the behavior of a System.Windows.Forms.Form (simply a form)... Read the rest of this entry →

Office COM add-ins and DPI awareness: research and analysis

In the first blog of this series, I showed issues related to using several monitors with different DPIs. To get an explanation of those pretty confusing results, let’s check resources available on the web.... Read the rest of this entry →

Issues with Windows mutli-DPI scaling and Office COM add-in panes and forms

Quite often these days you see this configuration: a notebook and an external display or two connected to the notebook. All these displays may have different DPIs. This is a typical environment where DPI-related issues reveal themselves. ... Read the rest of this entry →

New version of Add-in Express sample COM add-in projects

Quick news: we've developed a new version of sample COM add-in projects that we provide in the downloadable archive on the Add-in Express .NET Downloads page... Read the rest of this entry →

Support for Office 2019 is added to Add-in Express for Office and .net

Version 9.2 of Add-in Express for Office and .net is published, and we now announce full support for all versions of Office 2000 through 2019 32-bit and 64-bit... 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 →

Using Outlook Recipient and Recipients collection – guide for developers

Writing email can get you in a lot of trouble if you are not paying attention. I can tell you about some seriously funny (on retrospect) situations caused when I inadvertently added a recipient that I did not intend to add. I can tell you but I won't (unless we meet in person and you buy me a beer). Let's just say that Outlook's autofill feature is not your friend and is not to be trusted... Read the rest of this entry →

Outlook Address Book – complete guide for developers

Out-of-the-box, Outlook'is address book is the default contacts folder that resides in a user's Outlook folder structure. In a typical Outlook installation, there is a single contacts folder and feeds the TO, CC, BCC fields in the Outlook email form. In any form that supports assigning a contact to it, the default address book feeds it as well... Read the rest of this entry →

Exception from HRESULT 0x800A01A8 in PowerPoint solutions

On an example of a simple scenario, this article demonstrates what causes 0x800A01A8 and how to avoid it in C#, VB.NET, VBA, Delphi. Exception from HRESULT: 0x800A01A8 is also known as OLE error 800A01A8 and also known as Object Required.... Read the rest of this entry →

PowerPoint add-in development in Visual Studio: Application and base objects

Like all Office apps, the main object in the PowerPoint object model is the Application object. Underneath it we have a few key objects that will allow us to achieve most of our development goals. Here is summary of PowerPoint's base objects... Read the rest of this entry →

Creating a custom Send button in Outlook

Microsoft does not provide us with a way to customize the Send button using the Outlook object model. We can't change its caption, size, colors, etc. This is just how it is. Microsoft is happy with the Send button as-is and doesn't want us messing with it... Read the rest of this entry →

How to find the last used cell (row or column) in Excel

VB.NET code samples explain some reliable methods for finding the last used cell in an Excel worksheet or a range.... Read the rest of this entry →

Convert an Excel column number to a column name or letter: C# and VB.NET examples

There are a lot of examples floating around on the internet on how to convert Excel column numbers to alphabetical characters. There are a few ways to get the column letter, using either vanilla C# or VB.NET, Excel formulas or the Excel object model. Let's take a look at some of the solutions... Read the rest of this entry →

Working with Excel tables & ranges: VB.NET code samples

Microsoft Excel, being a spreadsheet application, automatically brings structure to your thinking. You can build models to help you think through just about anything. You can organize your data and create lists of any imaginable type. In fact, most apps in the mobile app stores these days can easily be replaced by Excel files. Even games... Read the rest of this entry →

Customizing Excel main menu, context menus, and Backstage view

Today we will tackle the issue of customizing Excel menus and back stage view. As you know, there are multiple versions of Excel "in-play" and it is wise to architect your solutions to work seamlessly with them. Add-in Express provides the tools, but it helps to know how to use them... Read the rest of this entry →

Excel add-in development in Visual Studio: Application and base objects

Today we start a new series to explain the basics (and more) of Excel add-in development. This is going to be serious fun because Excel rocks. Next to Outlook it might be the most popular target of Office add-ins... Read the rest of this entry →

Have any questions? Ask us right now!