Posts Tagged ‘COM add-ins’
Connecting Outlook appointments with Freshbooks web-service data, part 4
Pieter van der Westhuizen | November 14th, 2014
In this, our fourth and final part on how to write an Outlook add-in for Freshbooks web-service, we'll explore how to develop a custom form region to connect an Outlook appointment with the web-service's Timesheet entry... Read the rest of this entry →
Creating Outlook ribbon UI from scratch – Integrating with Freshbooks web-service, part 3
Pieter van der Westhuizen | November 6th, 2014
In this article, we'll continue with the add-in and tackle the process of hiding the standard Outlook Inspector and Explorer Ribbon tabs for the Freshbooks folders and items and replacing them with our own Freshbooks Ribbon Tabs... Read the rest of this entry →
Calling Freshbooks web-service from Outlook, part 2
Pieter van der Westhuizen | October 21st, 2014
In the previous article, we started with the basic concept and layout of our Freshbooks Outlook Add-in. So far, we've connected Outlook to the web-service by creating the Freshbooks specific folders, message classes and solution module, and in this article we'll continue building our Outlook plug-in... Read the rest of this entry →
Using Outlook Recipient and Recipients collection – guide for developers
Ty Anderson | September 18th, 2014
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 →
Calling Yahoo Weather web-service from an Outlook add-in
Pieter van der Westhuizen | August 21st, 2014
It's been a while since my last blog post and today we start the first in a series of exciting blog posts on integrating Microsoft Office applications with web-based services. The web is growing bigger and bigger by the day and there are a wide range of applications and services available on the internet which you can use to provide your users with more features and functionality inside Microsoft Outlook.... Read the rest of this entry →
Outlook Address Book – complete guide for developers
Ty Anderson | August 1st, 2014
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
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 →
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 →
How to find the last used cell (row or column) in Excel
Ty Anderson | December 6th, 2013
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 →
Loading a .NET 2.0 Office add-in on a machine with .NET 4.0
Andrei Smolin | December 4th, 2013
The fact is: almost all Office add-ins will load correctly in this situation. Yes, you don't need to modify anything in the add-in unless your add-in is affected by the issues described in .NET Framework 4 Migration Issues... Read the rest of this entry →
Populating Excel workbooks and ranges with arrays
Ty Anderson | November 29th, 2013
Microsoft Excel, with its almost endless supply of rows and columns, is data DisneyLand. It's fun to work with data and make it easy to consume. Part of the fun, at least for developers, is populating Excel with data. Today, I want to take another look at how to use arrays to populate Excel with data... Read the rest of this entry →
How to use Excel VBA macros and COM add-ins in one solution
Pieter van der Westhuizen | November 27th, 2013
The Microsoft Excel Office Object model is a varied and very mature framework and allows you to not only create VBA macros and functions but also COM add-ins. Of course creating these add-ins is made even simpler with the help of Add-in Express... Read the rest of this entry →
How to properly release Excel COM objects
Pieter van der Westhuizen | November 5th, 2013
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
Ty Anderson | October 31st, 2013
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 →