Posts Tagged ‘XLL’
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. 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 →
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 →
Creating integrated Office solutions with Add-in Express
Pieter van der Westhuizen | June 7th, 2011
Add-in Express enables you as a developer to quickly and easily create, not just MS Office add-ins but also Excel XLL add-ins, Excel Real-time data (RTD) servers and smart tags. In this post I'll demonstrate how you could include all this functionality in one Visual Studio project. Start by creating a new ADX COM Add-in project in Visual Studio... Read the rest of this entry →
Redeploying Office extensions via ClickTwice
Renat Tlebaldziyeu | March 1st, 2011
This is the final part of the series that describes all possible ways of deploying your Add-in Express-based Office extensions. I recommend that you begin from the very beginning: Step-by-step deployment of Office extensions: Overview. Or, if you are interested only in ClickTwice :) deployment, you can start right away with Deploying Office extensions via ClickTwice :)... Read the rest of this entry →
Deploying Office extensions via ClickTwice
Renat Tlebaldziyeu | February 28th, 2011
Part 7 of the deployment series explains how you can use your favorite installer software to deploy your Office extensions over the web; this is the essence of ClickTwice :). If you didn’t read the previous parts of the series, I'd advise that you start with Part 1 - a brief overview of the available deployment technologies... Read the rest of this entry →
Deploying per-user Office extensions via Group Policy
Renat Tlebaldziyeu | February 25th, 2011
This is part 6 of the deployment series that targets corporate deployment techniques and provides step-by-step instructions for deploying your per-machine Office extensions via Group Policy. I recommend that you start with reading Part 1 that gives a brief overview of all deployment technologies... Read the rest of this entry →
Redeploying per-user Office extensions via ClickOnce
Renat Tlebaldziyeu | February 24th, 2011
This is part 5 of the series of articles which describes all possible ways of deploying your Office extensions based on Add-in Express. I recommend you starting from the very beginning: Step-by-step deployment of Office extensions... Read the rest of this entry →
Deploying per-user Office extensions via ClickOnce
Renat Tlebaldziyeu | February 24th, 2011
In part 4 of the deployment series I will show you how to deploy your per-user Office extension using ClickOnce. Before we proceed, I recommend that you read Part 1 for a brief overview of all deployment technologies... Read the rest of this entry →
Deploying per-machine Office extensions via an MSI installer
Renat Tlebaldziyeu | February 22nd, 2011
This is part 3 of the deployment series that provides step-by-step instructions for deploying your per-machine Office extensions via an MSI installer. I recommend that you start with reading Part 1 that gives a brief overview of all deployment technologies... Read the rest of this entry →
Deploying per-user Office extensions via an MSI installer
Renat Tlebaldziyeu | February 22nd, 2011
This is part 2 of the series that covers all possible ways of deploying Add-in Express based Office extensions. Part 1 provided a brief overview of the available deployment technologies and now we are going to have a close look into deploying per-user Office extensions via an MSI installer... Read the rest of this entry →
Deploying Office extensions – step-by-step guide
Renat Tlebaldziyeu | February 22nd, 2011
The table below gives an overview of the main features supported by the above mentioned technologies that you can use for deploying your Add-in Express based Office extensions... Read the rest of this entry →
XLL Add-ins and Add-in Express 2010
Pieter van der Westhuizen | June 22nd, 2010
As I've mentioned in one of my previous posts, Excel has become one of my favourite reporting tools in the last few years. It is also the primary tool for anyone doing a data clean-up or conversion project... Read the rest of this entry →
Video HowTo: Creating an XLL add-in for Excel 2000 – 2007 (VB.NET)
Dmitry Kostochko | April 23rd, 2010
Looking at the list of already published video howto samples, I just realized that most of them target Outlook. This is no wonder at all, because every MS Office developers would confirm that Outlook is the most in-demand application from the Microsoft Office family... Read the rest of this entry →
