‘HowTo samples’ category archive

Creating and modifying PowerPoint presentations (end-to-end sample)

We're drawing our PowerPoint series to a close and it only makes sense to end with an "end-to-end" sample. See what I did there? We've covered the base objects and provided code samples. Today, I'll tie them together in a single add-in that supports a specific business use case... Read the rest of this entry →

Creating and modifying MS Project files programmatically

In my last two articles we looked at the MS Project object model and how to customize the MS Project UI. In this article, we'll take what we've learned and explore how you can use data from other sources to either create or add to your MS Project files.... Read the rest of this entry →

Project 2013 UI customization

When it comes to developing add-ins for Microsoft Project you cannot be blamed for feeling that MS Project is a bit of a second-rate citizen in the MS Office suite of products. Its object model does not feel quite as polished as the Microsoft Word, Outlook, PowerPoint and Excel object models... Read the rest of this entry →

Programming for Microsoft Project 2013

Microsoft Project is a product that not many people realize is part of the Microsoft Office family. It is also a product that most users do not have on their PC. Where you do see it, however, is on the computer of many project managers and herein lies the opportunity for us as Office developers... 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 →

Working with custom Outlook properties: C# code examples

Microsoft Outlook provides a rich interface for developers to add their own custom properties to Outlook Folders and Items. The Outlook Object model provides two objects when working with custom properties... Read the rest of this entry →

How to create and modify Outlook-specific files

Microsoft Outlook produces and uses a variety of file types. The most common and well known fields are either .pst or .ost files. These two file types are known as Outlook Data Files, the .pst file is known as the Personal Outlook Data file and stores you messages and other Outlook items... Read the rest of this entry →

Create a status report generator using Excel and Outlook: C# sample

Today, I'll show you how to create a status report using Excel and Outlook. This add-in sample will run within Excel. The user will have a button to click that starts the report process. Instead of creating a new workbook or worksheet, the add-in will insert the task status report into the existing spreadsheet... Read the rest of this entry →

How to import contacts and appointments from Excel into Outlook and vice-versa

Importing contacts and appointments into Microsoft Outlook is a feature that has existed in Outlook for a while. In Outlook 2013 you can find the Import/Export function in the File or Backstage view menu, under Open & Export... 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 →

How to properly release Excel COM objects

You'll see a lot of complaints on the internet about Excel and other Microsoft Office applications not quitting properly after using the object model to perform certain actions, or showing sporadic and unpredictable behavior in COM add-ins. In the end most of these issues boil down to developers not properly disposing of COM objects... Read the rest of this entry →

Working with Excel pivot tables: VB.NET code examples

Today, I'll show-off some code that shows how to automate pivot tables. It's quite likely your user base is 100% comprised of uber-serious spreadsheet jockeys. These people need your help. This code will help you relate to them and make their life easier... Read the rest of this entry →

Importing data from SQL databases and other sources to Microsoft Excel

A number of people I've met had no idea about one of Microsoft Excel's most powerful features. I'm talking about the ability to add data from external sources to your Excel sheet and manipulate it from there. Of course as a developer this can come in very handy when you want to provide your users with an intuitive and flexible way to access your data and empower them to create their own reports... 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 →

Working with Excel charts: how to change a chart style, color or type programmatically

Adding charts in your Excel add-ins using the Excel object model is easier than you might think. In this article we'll take a look at how to insert charts programmatically, format their style and colors as well as how to change the chart's display by filtering its data... Read the rest of this entry →

Have any questions? Ask us right now!