Posts Tagged ‘Excel’
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 →
Advanced Office task panes and Office 2010 – first view
Eugene Starostin | April 22nd, 2010
Advanced Office task panes in Office 2010 have no principle differences from those of any other Office versions, they just work and that's it. That's why this subject is so arid, that I won't get back to it anymore. However, after scrutinizing all the above screenshots, I see that we will definitely ennoble certain "pixels"... Read the rest of this entry →
Video HowTo: Resize Advanced Task Pane programmatically (VB.NET)
Dmitry Kostochko | April 9th, 2010
To resize your custom Office task pane, you need to use the trivial Width and Height properties of the particular instance of your task pane. There is just one important thing - the Splitter property should be set to None... Read the rest of this entry →
Video HowTo: ClickOnce installation for Office add-in in minutes (VB.NET)
Dmitry Kostochko | March 26th, 2010
This visual sample is purposed mainly for novices in Office development. It demonstrate the facilities of the ClickOnce technology with regard to installation of a simple Excel add-in based on Add-in Express with Advanced Excel Task Panes... Read the rest of this entry →
HowTo: Create a COM add-in, XLL UDF and RTD server in one assembly
Andrei Smolin | March 24th, 2010
You know, a pessimist differs from an optimist by his attitude to a glass: the former thinks the glass is half empty, while the latter considers it's half full. When I was contemplating on the circumstances that made me write this post, I worked out another definition... Read the rest of this entry →
HowTo: Register your MS Office add-in with WiX
Fokke Post | February 8th, 2010
If you are using Microsoft’s WiX toolset to build a setup for your Add-In, then there are several ways to register the Add-In. I’ve seen examples that use a custom action to call RegSvr32.exe to do the registration. But since RegSvr32.exe does nothing more than calling the DllRegisterServer function of our Add-In, why not calling that directly from a custom action?... Read the rest of this entry →
Video HowTo: Develop an RTD Server for Excel 2002 – 2007 in VB.NET
Dmitry Kostochko | December 24th, 2009
In this short video we will show you how to develop an RTD Server using Add-in Express for Office and .NET. In the next 2 minutes you will get the basic notion of real time data server: how to create it, return a value and see how the RTD server works in Excel... Read the rest of this entry →
Video HowTo: Create a Smart Tag for Excel 2002 – 2007 in VB.NET
Dmitry Kostochko | December 18th, 2009
After COM add-ins and RTD servers, smart tags are arguably the third most-in-demand extensions in Microsoft Office world. In today's video sample we are going to show you how to develop a smart tag for Microsoft Excel XP, 2003 and Excel 2007... Read the rest of this entry →
Video HowTo: Create an Excel COM add-in in Visual Studio
Dmitry Kostochko | December 5th, 2009
This sample starts the new series of visual HowTo. We thought it would be a good idea to give you a sort of hands on training with Add-in Express. Today we are going to look at one of the most frequent tasks, creating a COM add-in for Microsoft Office.... Read the rest of this entry →
HowTo: Support Office 2007 color schemes in your custom forms and task panes
Dmitry Kostochko | May 1st, 2009
In Office 2007 there are 3 available color schemes – Black, Blue and Silver. The background of controls in command bars and ribbon tabs is changed by Office automatically. Do you want to try changing the background of your Outlook forms and Excel task panes when the MS Office color scheme is changed?... Read the rest of this entry →
Office Alarm – Excel experienced a serious problem with the ‘microsoft office live add-in’
Eugene Starostin | April 30th, 2009
Strange things started happening around us. Swine flu added to the global economic crisis, and we have problems with Office 2007 and the Office Live Add-in added to our pre-release testing for compatibility with the recently released Office Service Pack 2. The fact of the matter is that... Read the rest of this entry →
Hint: How to completely reset Outlook regions
Eugene Starostin | April 29th, 2009
When Outlook is closing, Add-in Express saves the state of all regions embedded into Outlook, namely their position (if drag-and-drop is turned on), state (regions can be minimized or entirely hidden) and size (if resizing is allowed). We implemented this feature just to give end-users the utmost comfort when working with Outlook regions... Read the rest of this entry →
Complete review – Advanced Outlook Regions, part 4
Eugene Starostin | April 29th, 2009
In version 2009 of Add-in Express, a new property appears - RestoreFromMinimizedState. Now I will show you its behavior. Let's say, we have a minimized by default region... Read the rest of this entry →
Add-in Express 2009 – Beta 1 what’s fixed
Eugene Starostin | March 2nd, 2009
As compared to the previous generation, Add-in Express 2009 doesn’t contain revolutionary changes or enhancements. We have not rewritten the core code completely, the major part of the time was spent on the most in-demand features, such as Outlook view and form regions and Excel, Word and PowerPoint task panes... Read the rest of this entry →
Add-in Express 2009 – Beta 1 Excel capabilities
Eugene Starostin | March 2nd, 2009
In addition to bug fixes, which I must admit were not too numerous, and some platform-dependent modifications and enhancements concerning Excel, we've decided to improve Advanced Excel Task Panes as well... Read the rest of this entry →
HowTo: Fix “Old format or invalid type library” error (0x80028018)
Dmitry Kostochko | February 13th, 2009
Today I’d like to draw your attention to one specificity of the Excel Object Model that every .NET developer should be aware of. Those who are unaware, may get the notorious "Old format or invalid type library" error...... Read the rest of this entry →