Posts Tagged ‘Office’
Invoking a COM add-in from an Excel XLL add-in: advanced sample
Andrei Smolin | October 11th, 2011
Really often, when I saw an error returned by an Excel formula, I thought about the poor possibilities that this error-reporting approach – a remnant of bygone concepts – provides for developers. The very first time I thought about showing a custom task pane from a UDF was when Add-in Express allowed showing custom panes in Excel; it was back in 2007... Read the rest of this entry →
How To: Create a new Outlook Contact item programmatically
Eugene Astafiev | October 7th, 2011
Not so long ago I described various ways of creating Outlook messages programmatically. Today we will examine contact items. The first and easiest way of creating a new Contact item in Outlook is to use the CreateItem method of the Application class... Read the rest of this entry →
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 →
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 →
HowTo: Replace the standard Outlook Task UI
Pieter van der Westhuizen | September 28th, 2011
Add-in Express for Office and .net version 6.4, introduced us to the CompleteReplacement Outlook form region in March this year. With this region you are able to completely replace the entire area of an Outlook Inspector... 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 →
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 →
How to get and set the format of an Outlook email message
Andrei Smolin | September 19th, 2011
Outlook supports creating emails in plain-text, HTML and RTF (rich-text) formats. To get or set the format of an email message, you use the MailItem.BodyFormat property; it isn't available in Outlook 2000. The value returned by the property is one of the Outlook.OlBodyFormat constants... 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 →
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 →