Posts Tagged ‘C#’
How to integrate Outlook add-in with Freshbooks web-service, part 1
Pieter van der Westhuizen | October 6th, 2014
In this article, the first of a series, we'll start building a Microsoft Outlook Add-in that will serve as a client for Freshbooks. Users would be able to view their Freshbooks data as well as perform numerous Freshbooks tasks all from within Outlook... Read the rest of this entry →
Creating an Excel Stock Information RTD server using the Yahoo Finance API
Pieter van der Westhuizen | September 25th, 2014
In today's article, we'll write an Excel RTD server that returns the latest stock prices and other information. In case you're not familiar with Excel RTD servers, it is used to communicate with a real-time data source, such as stock quotes and provide the user with a constant flow of changing data... Read the rest of this entry →
Exception from HRESULT 0x800A01A8 in PowerPoint solutions
Andrei Smolin | June 24th, 2014
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 →
Creating Microsoft InfoPath add-ins in Visual Studio with Add-in Express
Pieter van der Westhuizen | March 6th, 2014
Earlier this year, Microsoft has also announced that it will discontinue InfoPath to pursue a more integrated experience for Office forms. So look out for some InfoPath features being integrated into Word, Access and SharePoint in the future!
... Read the rest of this entry →
Creating and modifying MS Project files programmatically
Pieter van der Westhuizen | February 28th, 2014
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
Pieter van der Westhuizen | February 21st, 2014
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
Pieter van der Westhuizen | February 14th, 2014
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 →
Working with custom Outlook properties: C# code examples
Pieter van der Westhuizen | January 15th, 2014
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 →
Working with Outlook special folders (Inbox, Outbox, Drafts, Sent Items, Deleted Items)
Pieter van der Westhuizen | January 9th, 2014
Happy 2014 everyone! We'll start this year with an article looking at Outlook special folders. Microsoft Outlook has a number of special folders of which the most common folders are: Inbox, Drafts, Sent Items, Outbox and Deleted Items. Now let's have a closer look at each of the Outlook special folders and see how to work with them in the most efficient manner.... Read the rest of this entry →
How to create and modify Outlook-specific files
Pieter van der Westhuizen | December 20th, 2013
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
Ty Anderson | December 16th, 2013
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
Pieter van der Westhuizen | December 11th, 2013
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 →
Convert an Excel column number to a column name or letter: C# and VB.NET examples
Pieter van der Westhuizen | November 13th, 2013
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 →
Importing data from SQL databases and other sources to Microsoft Excel
Pieter van der Westhuizen | October 30th, 2013
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 charts: how to change a chart style, color or type programmatically
Pieter van der Westhuizen | October 22nd, 2013
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 →
Working with Excel cell values, formulas and formatting: C# code samples
Pieter van der Westhuizen | October 15th, 2013
If you look at the title of this article, it almost sums up what Microsoft Excel is. Without cells, values and formulas, you just cannot get much done in Excel. Of course everything is contained within worksheets and workbooks and you can do so much more with Excel, but at the heart of it all lies cells... Read the rest of this entry →