Posts Tagged ‘Excel’
Building a Real Time Data server for Excel: Avoiding VSTO, part 2
Maurice Calvert | January 13th, 2011
When I first started programming addins for MS Office, I took the obvious road of installing Visual Studio Tools for Office (VSTO). It all seemed rather easy and I had a toy excel addin completed in the first evening. My enthusiasm was quickly doused when I tried to deploy the addin. ... Read the rest of this entry →
Building a Real-Time Data server for Excel, part 1
Maurice Calvert | January 12th, 2011
In my series of posts I will describes the techniques necessary to build a Real Time Data (RTD) server for Microsoft Excel. It is based on what I learned whilst coding GeodesiX, an Excel addin that uses the GoogleMaps APIs to provide Excel formulas to fulfil these functions
... Read the rest of this entry →
Advanced region events: how to know that the user expanded your form?
Fedor Shihantsov | January 11th, 2011
Hello folks! Through our forums and e-mail, we are frequently asked questions like this by our fellow developers: How do I know that the user expanded my Add-in Express form? In this article, I will cover the events that are raised when the region is expanded and other events that occur when the region's state is changed... Read the rest of this entry →
100% version neutrality for your Office extensions
Pieter van der Westhuizen | December 13th, 2010
Finally, when you completed your add-in, there is no need to build separate setup programs for different versions of Office. Generating a setup program is as simple as right-clicking your project in the Visual Studio Solution Explorer and selecting Create Setup Project from the context menu... Read the rest of this entry →
Video: Create an Office shared add-in – building the GUI
Ty Anderson | September 13th, 2010
I like to tinker with new technologies to see what they can do and how I could potentially use them in the solutions I build for my clients. A lot of the times my tinkering never leads to full understanding of the technology. In such cases, I don't blame myself nor my sometimes fickle love for the latest shiny bits... Read the rest of this entry →
Office 2010 Admin Templates and Add-in Express
Pieter van der Westhuizen | July 12th, 2010
If you look at the list of known issues for the latest release of Add-in Express 2010, you'll notice a specific issue I myself ran into not so long ago: WebViewPane region cannot be used for folders if their WebViewOn and WebViewUrl properties cannot be set. Possible solution is setting the "Allow Script in shared folders" and "Allow Script in Public Folders" options in the security settings
... Read the rest of this entry →
RTD Servers and Add-in Express 2010
Pieter van der Westhuizen | July 5th, 2010
Real-time data (RTD) is data that updates on its own schedule. The most common example is stock quotes, warehouse activities and web server loads. In this post, Northwind Traders has requested a sales dashboard in Excel that updates sales figures and targets dynamically by reading order information from their sales database... Read the rest of this entry →
HowTo: Communicate with a COM add-in from a standalone application
Dmitry Kostochko | July 2nd, 2010
In order to get a standalone application to communicate with a COM add-in, the application needs to have access to the running host application (Microsoft Excel in our case), get the COMAddins collection, find a needed instance of the add-in there and use reflection to call public methods or retrieve public properties... Read the rest of this entry →
Video: Build and control Advanced Task Panes in Add-in Express 2010
Ty Anderson | July 1st, 2010
What I really write about today is the topic of Office task panes. Office 2003 calls them action panes. Office 2007 and 2010 call them custom task panes. At Add-in Express , they are known as Advanced Task Panes. What are they?... Read the rest of this entry →
Smart Tags and Add-in Express 2010
Pieter van der Westhuizen | June 28th, 2010
Smart Tags is a feature in Office by which Word, Excel, PowerPoint and Outlook (if Word is used as the default editor) recognizes certain words and then presents the user with additional actions based on the selected text. It is available in Office 2002 to 2007, it is noticeably absent in Office 2010 as it has been deprecated, meaning that Word, Excel, PowerPoint and Outlook will not automatically recognize words as in the previous versions... Read the rest of this entry →
Controlling Outlook region’s state and form’s size in Add-in Express 2010
Fedor Shihantsov | June 25th, 2010
Here I will tell you how and where you can control the state of the regions where a custom task pane or an Outlook region is located, and also show how you can control the size of those forms... 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 →
Office 2010 as development platform
Pieter van der Westhuizen | June 14th, 2010
By the time this blog post is published, the kick-off between South Africa and Mexico officially started the FIFA World Cup 2010! Just as South Africa has come a long way in preparing for the first football World Cup on African soil, so too has Office evolved into a promising and stable platform for developers to deliver ground breaking and exciting solutions for their customers and users... Read the rest of this entry →
Add-in Express 2010 and Office add-ins: Getting started
Pieter van der Westhuizen | May 14th, 2010
I have used Add-in Express before and can honestly say that if you want to develop an MS Office add-in this product is definitely a worthwhile investment. In this post I’ll explain the benefits and some of the key features of Add-in Express 2010 for Office and .net when creating a small Office Add-in that is shared among Excel, Word and Outlook.... Read the rest of this entry →
Video HowTo: Create advanced task panes in Excel, Word and PowerPoint (Delphi)
Dmitry Kostochko | May 14th, 2010
As you probably know Add-in Express for Office and VCL allows creating advanced task panes for MS Excel, Word and PowerPoint 2000-2010. Today we'll develop a single add-in project that supports Excel, Word and PowerPoint... Read the rest of this entry →
Video HowTo: Support Office command bars and Ribbon UI in one add-in project (VB.NET)
Dmitry Kostochko | April 30th, 2010
Add-in Express supports creating COM add-ins for Office 2000 - 2010. Office 2000, XP and 2003 have a traditional command bar-based user interface, while Office 2007 is partially and Office 2010 is fully ribbonized. "How is it possible to support both types of user interfaces in one COM add-in project?" you may ask... Read the rest of this entry →