Posts Tagged ‘.NET’
Thread-safe XLL. How to get the caller address
Andrei Smolin | October 7th, 2011
The implementation of ADXExcelRef.ConvertToA1Style (ConvertToR1C1Style) uses xlfRefText which is NOT thread-safe as per Financial Applications Using Excel Add-in Development in C/C++ (2nd edition). On the other hand, xlSheetNm returning the sheet name is thread-safe. It means that the thread-safe way to get the caller address is to write some code... Read the rest of this entry →
How To: Perform Send/Receive in Outlook programmatically
Eugene Astafiev | October 5th, 2011
Today I will continue my series of "How To" articles explaining the basics of Outlook development. The NameSpace class in Outlook provides a programmatic equivalent of the "Send/Receive All" command – SendAndReceive method
... Read the rest of this entry →
How to use Evaluate to invoke an Excel UDF programmatically
Andrei Smolin | October 3rd, 2011
Whether your UDF is a VBA macro or an Excel Automation add-in or even an XLL add-in, you can invoke any method it provides to the user. To do this, you need to get or create an Excel.Application object and invoke ExcelApp.Evaluate() supplying it with the correct syntax for your method and its parameters.... Read the rest of this entry →
Outlook NewMail event unleashed: the challenge (NewMail, NewMailEx, ItemAdd)
Pieter van der Westhuizen | October 3rd, 2011
A while ago Eugene asked me whether I would be interested at taking an in-depth look at how to effectively handle a new mail in Microsoft Outlook. I mean how hard could it be? We have the NewMail and NewMailEx events and if all else fails we can use the Folder Item Add event, right... Read the rest of this entry →
Creating a fast Excel add-in (C#, VB.NET). Reading and updating cells.
Andrei Smolin | September 29th, 2011
This is a known problem: doing things cell by cell in Excel is a slow operation. The Excel object model provides two ways to speed up the code... Read the rest of this entry →
How To: Get unread Outlook e-mail items from the Inbox folder
Eugene Astafiev | September 27th, 2011
In my previous articles we discussed the Find, FindNext and Restrict methods of the Outlook Items class. You can use these methods for retrieving unread items in the way I did... Read the rest of this entry →
Fast Excel add-in. Checking incoming data in XLL
Andrei Smolin | September 23rd, 2011
When in an Excel UDF you need to check incoming data and replace incorrect values, you can use the modified-in-place argument, the XLL feature supported by Add-in Express 2010 for Office and .net.
... Read the rest of this entry →
How To: Use Restrict method to retrieve Outlook mail items from a folder
Eugene Astafiev | September 23rd, 2011
In my previous article I demonstrated how you can use the Find and FindNext methods of the Items class in Outlook. Today I want to show you an alternative way of retrieving Outlook mail items from a folder. As the post's title suggests, the Restrict method plays the key role in the process... Read the rest of this entry →
Video: Implementing a custom UI for Office add-ins with ClickOnce
Ty Anderson | September 22nd, 2011
Sometimes I get on a roll. Currently that roll is "customizing deployment packages". Yesterday, I subjected you to a video that shows you how to customize a ClickTwice deployment to include a EULA (among other things). Today, I have some ClickOnce goodness for you... Read the rest of this entry →
Video: Customizing a ClickTwice deployment package of your Office add-in
Ty Anderson | September 21st, 2011
When you build an Office add-in, your users' first impression will be based on the installation experience. I know…it isn't fair…but it's true. This fact means they will judge your app before they have encountered it. So you need to provide a quality installation experience
... Read the rest of this entry →
How To: Use Find and FindNext methods to retrieve Outlook mail items from a folder (C#, VB.NET)
Eugene Astafiev | September 20th, 2011
As you have probably guessed, this article will describe the Find and FindNext methods of the Outlook Items class. But before focusing on the functionality of these methods, I would like to draw an analogy with database programming in the .NET world. In ADO.NET there is the System.Data.SqlClient.SqlDataReader class which provides the Read method... Read the rest of this entry →
Outlook Items and Folders events explained: C# code sample
Pieter van der Westhuizen | September 13th, 2011
In this post, we'll have a closer look at two classes provided by Add-in Express: the Outlook Folders Events class and the Outlook Items Events class. I'll be using Add-in Express 2010 for Office and .Net and Visual Studio 2010... Read the rest of this entry →
How To: Change an Outlook e-mail message before sending using C# or VB.NET
Eugene Astafiev | September 12th, 2011
As a developer you may want to modify an e-mail before sending it (or just add some information, such as a non-disclosure agreement etc.). It is a fairly simple task that every Outlook developer should be familiar with. For example, sometimes you may need to change the subject of a message by adding an ID or something else to track the item in your Inbox; add something to the e-mail body... Read the rest of this entry →
Video: Create advanced form regions for Outlook 2013, 2010, 2007 (C#, VB.NET)
Ty Anderson | September 9th, 2011
A few weeks ago I did a short video to introduce our new product known as Add-in Express Regions for Microsoft Outlook and VSTO. I thought it time to take things up a notch and provide a solid sample that implements advanced form regions in a VSTO project and also accesses the Outlook object model in a meaningful way... Read the rest of this entry →
How To: Fill TO,CC and BCC fields in Outlook programmatically
Eugene Astafiev | September 8th, 2011
In my previous article, where I showed how to create and send an Outlook message programmatically, I added a recipient to the e-mail. Now I want to delve deeper and show you what you can do with the Recipients collection. Outlook developers frequently need to add recipients to the TO, CC and BCC fields... Read the rest of this entry →
Video: Building an Excel RTD server
Ty Anderson | September 8th, 2011
Using Add-in Express you have the tools you need to rapidly start building a Real-Time Data (RTD) Server for Excel. This video shows you to use ADX to build a simple RTD... Read the rest of this entry →