Posts Tagged ‘VB.NET’

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 2013 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 →

Using custom XML parts in Word add-ins

Custom XML parts are chunks of XML that reside within a Word document. They are not part of the document, per se, because they are not visible to the user. Starting with Office 2007, the Office file formats are XML-based and are comprised of XML parts... Read the rest of this entry →

Working with Word document designs, styles and printing

Designing Microsoft Word documents is not all that different from designing a web page; you want to keep the content and the design separate. In Word, you keep them separate by utilizing styles. Styles include a plethora of design elements (e.g. font, borders, paragraph format, etc). Let's have some fun with them via code... Read the rest of this entry →

Working with Word document content objects

Microsoft Word is about the authoring of documents. Documents contain pages, paragraphs, sentences and more. Today, I want to wade into the waters of manipulating Word document content. The plan is to get your feet wet by providing an overview of the key objects along with code samples... Read the rest of this entry →

Customizing Microsoft Word ribbons and toolbars: VB.NET, C#

A popular user interface customization is custom ribbons and custom toolbars. I think you know what these are and we'll cover how to create both of them for Microsoft Word. We'll start with Ribbon and work our way back to the legacy toolbars (aka CommandBars). ... Read the rest of this entry →

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

In this article, the first in a series of Word development topics, I'll cover Microsoft Word application and base objects. And, as is our tradition, I'll provide relevant code samples for Word 2013 - 2000 you can copy and paste into your solutions... Read the rest of this entry →

Have any questions? Ask us right now!