Posts Tagged ‘Excel’

Add-in Express vs. VSTO – Microsoft Office developer happiness

This being the eighth and final instalment of the Add-in Express vs. VSTO series, I thought I'd wrap up with what could possibly be the most important feature of Add-in Express: Developer Happiness... Read the rest of this entry →

Add-in Express vs. VSTO: Custom Office task panes

A task pane is a dockable window which was first introduced in Microsoft Office XP. It provided a new and convenient way for users to gather information and access common features and commands. Chances are that if you’ve used any application in the Microsoft Office suite you would have used a task pane... Read the rest of this entry →

Add-in Express vs. VSTO: Customizing Backstage View and context menu

One of the first articles I wrote for Add-in Express was about the Office 2010 Backstage View. Microsoft Office 2010 was still new and users of Office where still getting used to Microsoft's new approach to the "File" menu. The Add-in Express Backstage view component has since received a new and very impressive visual designer that makes designing the Backstage view a piece of cake ... Read the rest of this entry →

Excel shapes events: getting notified about user actions

The Excel object model doesn't have any events purposed for manipulations with shapes. In this blog I demonstrate an approach to solving this problem... Read the rest of this entry →

Video: Create an Office shared add-in – building a custom Click Twice deployment package

The video, Part 5, is the last of the series. In this 15-ish minute video, you will learn how to build a Click Twice deployment package for the MyTasks add-in. Click Twice is one of the major strengths of the Add-in Express toolset... Read the rest of this entry →

Video: Create an Office shared add-in – connecting business logic to Office events

On Tuesday we published Part 3 of the end-to-end demo. Today, we have Part 4. In reality parts 3 and 4 can be taken together but we thought it's better to break them up a bit and provide a bit of a break. But we have momentum now so let's keep this train a-moving because Part 5 is almost ready for its debut as well.... Read the rest of this entry →

Video: Create an Office shared add-in – interacting with Office object models & events

I admit some time has passed since we produced parts 1 and part 2 of our end-to-end demo. I'll take the blame for it. It's okay. But I want you to know the remaining parts have been sitting in my Outlook Tasks folder… staring at me… taunting me. ... Read the rest of this entry →

How to load your Office COM add-in on condition

A typical problem is: how to unload my add-in if a custom condition is met. This blog post is about how to solve this problem.... Read the rest of this entry →

How to navigate through the Microsoft Office Command Bar system

There are 4 instances of the command bar button "Save" (Id=3) in Excel. Two of them are best known: a button on the Standard commandbar and an item in the File menu. The other two instances are buried in the command bar system... Read the rest of this entry →

How to create a custom event when Excel calculation mode changes

You should be aware that no such event exists. Let's create it. In Excel 2007 - 2010, you can change the calculation mode using the buttons shown in the screenshot below... Read the rest of this entry →

Why doesn’t Excel quit?

From my experience, Excel doesn't quit because there's a COM object left unreleased either in your code or in the code of a COM add-in loaded in Excel. That is, to debug such an issue, you need to start with turning all COM add-ins off... Read the rest of this entry →

How to add PivotTables and Slicers to MS Excel programmatically

As I've mentioned in my previous article Excel enables us to provide our users with interactive and powerful ways to visualize their data. Pivot tables add another dimension to this by summarizing thousands of records of data in one page and let you analyse trends in your data without the need for formulas... Read the rest of this entry →

Invoking a COM add-in from an Excel XLL add-in: advanced sample

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 →

Thread-safe XLL. How to get the caller address

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 use Evaluate to invoke an Excel UDF programmatically

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.

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 →

Have any questions? Ask us right now!