Posts Tagged ‘Excel’
Video: Create an Office shared add-in – connecting business logic to Office events
Ty Anderson | January 26th, 2012
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
Ty Anderson | January 24th, 2012
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
Andrei Smolin | January 20th, 2012
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
Andrei Smolin | January 16th, 2012
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
Andrei Smolin | December 5th, 2011
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?
Andrei Smolin | November 4th, 2011
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
Pieter van der Westhuizen | October 17th, 2011
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
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 →
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 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 →
Fast Excel add-in. 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 →
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 add sparklines and charts to MS Excel programmatically
Pieter van der Westhuizen | September 21st, 2011
The charting engine for Excel took a leap forward with the release of Office 2007. However, the engine was slower than Excel 2003's version and also introduced a few bugs. Luckily Excel 2010 fixed those bugs and is back to being fast. Sparklines, a word-sized chart has also been introduced in Excel 2010... 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 →
Video: Developing an Excel Automation Add-in
Ty Anderson | August 31st, 2011
As a follow up to the Creating managed Excel UDFs video, here is a video that explains how to build UDFs using Excel Automation add-ins. In addition to a solid demo, this video explains the differences between an UDF built with an Automation Addin and one built as an XLL... Read the rest of this entry →
Video: Creating managed Excel UDFs – XLL based user-defined functions
Ty Anderson | August 4th, 2011
Creating custom User Defined Functions (UDFs) is one of the most popular reasons to build an Excel add-in. Add-in Express for Office and .NET supports two methods for building custom UDFs... Read the rest of this entry →
