Posts Tagged ‘Excel’
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 →
How to allow a user to choose target MS Office applications during installation
Pieter van der Westhuizen | July 5th, 2011
In today's post I'll demonstrate how you can customize your add-in setup project to allow your users to select which Microsoft Office applications the add-in will be installed for. I am using Add-in Exprewss 2010 for Office and .net... Read the rest of this entry →
Video: Handling Office keyboard shortcuts
Ty Anderson | June 22nd, 2011
For almost every menu and/or Ribbon command in Microsoft Office, there is a keyboard shortcut for it. These shortcuts allow you to quickly and easy execute a command with a key stroke that might take several clicks of the mouse... 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 →
Video: Advanced Task Panes – extend the UI of Excel, PowerPoint and Word
Ty Anderson | May 12th, 2011
People use Microsoft Office for all sorts of tasks in order to get their work done. For example, they use Word to write proposals, they use PowerPoint to create awesome marketing presentations, and then they use Excel to calculate their commissions. But the thing is often users need to leave Office to go and gather information that they need to complete the document... Read the rest of this entry →
Video: Fully-featured solutions for all Excel add-in types
Ty Anderson | May 10th, 2011
Microsoft Excel supports multiple types of add-in architectures, from XLLs to user-defined functions and COM add-ins to real-time data servers. Each have their own interface in Excel and each require separate sets of technical knowledge to use them effectively leaving a developer just wondering where to begin... Read the rest of this entry →
Creating an Office COM add-in: getting started for VB developers
Pieter van der Westhuizen | May 2nd, 2011
How to quickly create a shared COM add-in for Microsoft Outlook, Excel and word in VB.NET. Sample add-in is available for download.... Read the rest of this entry →
How to install multiple Office add-ins using one setup project
Pieter van der Westhuizen | March 30th, 2011
In today's post I'll demonstrate how you can install multiple Add-in Express Microsoft Office Add-ins without building multiple setup programs. Start by creating a new ADX COM Add-in project in Visual Studio
... Read the rest of this entry →
How to check programmatically if the user is editing an Excel cell
Andrei Smolin | March 23rd, 2011
Here's a typical scenario: your code modifying a workbook fails because the user types something into a cell. Now how to determine that Excel is in the edit mode?
... Read the rest of this entry →
Video: How Add-in Express makes Office development rewarding
Ty Anderson | March 10th, 2011
Office development is a rewarding experience providing you the developer using Visual Studio the opportunity to impact the lives of users of all shapes and sizes. Using Office as the development platform, you can build solutions that integrate with your users' business processes and simplify their life... Read the rest of this entry →
Video: How Microsoft Office abuses its developers and how Add-in Express stops this
Ty Anderson | March 10th, 2011
If you have any experience in developing solutions on the Office platform, you have most likely learnt that Office has the tendency to abuse its developers. One of the main reasons for this is that Office is comprised of several different applications like Outlook, Excel, PowerPoint and Word, and each of these applications has their own object model that you need to understand and master when building your solutions... Read the rest of this entry →
Video: Create an Office shared add-in – building advanced task panes and advanced Outlook regions, using advanced controls
Ty Anderson | February 7th, 2011
I admit it…it's been awhile since we published Part 1. So I don't blame you if gave up hope of ever seeing Part 2. But I'm here to tell you that you have not waited in vain because today we present to you Part 2 of the Create an Office Shared Add-in series... Read the rest of this entry →