VBA to Visual Studio Tools for Applications Migration

“How do I migrate my code from VBA to VSTA?”, is a common question that is asked by many people. The short answer is that VBA code and VSTA code can run side-by-side. So if you have an existing VBA program it will continue to work. If you are creating a new program it should…


VSTA: What is an Add-in?

This is an excellent question posed by TQ, one of our architects, on his blog. The definition of an add-in is: An “Add-in” is any component that is dynamically discovered and loaded by its host. It usually is compiled separately from the host and the host and Add-in version independently of each other. The host…


The History of Application Customization

VSTA is all about application customization with the .Net framework, but the history of application customization is a long one at Microsoft. Scott Wiltamuth who was here at Microsoft for most of it has an excellent walk down memory lane in his blog. Scott Wiltamuth’s C# blog .  Be sure to visit the VSTA team…


Announcing Visual Studio 2005 Tools for Applications

Today at PDC05 they announced a new product that I have been working on for the last 2 years. So it is exciting for me to be able to finally share with you all what I have been working on. Visual Studio Tools for Applications (VSTA) is a .NET-based application customization technology designed to be…


How To: Dynamic CSS Action Panes in Office

In my last post How to Create HTML Action Panes for Word and Excel using VSTO 2005 I showed a simple but powerful technique to use HTML pages in the Word or Excel Task Pane. In this post I will show you how to extend this to use dynamic Cascading Style Sheets (CSS). Dynamic CSS allows…


How to Create HTML Action Panes for Word and Excel using VSTO 2005

VSTO 2005 enables developers to create Windows form Action Panes in Word and Excel with only 1 line of code. I will show you how to extend this technique to create an Action Pane using HTML. Why would you want to use HTML for a client side application when you have the power of Windows…


Hands-on Labs: Learn how to use VSTO 2005

The VSTO 2005 Hands-on Labs are now available. The Word labs walk you through the task of building a customer survey application. The Excel labs walk you through the task of building an asset allocation application and a debt consolidation application Get started today with VSTO 2005, download the labs here: ·  Word Labs · …


Announcing VSTO 2005 for Outlook 2003

Today during Steve Ballmer’s keynote speech he announced VSTO for Outlook. Now in addition to Word and Excel, you can create Outlook add-ins using VSTO 2005 for Office 2003. VSTO will create managed add-ins for Outlook that will appear to Outlook as a COM add-in. VSTO for Outlook also fixes some of the problems associated…


Live from TechEd 2005

Today is the start of TechEd 2005 in Orlando. Today’s events consist mainly of pre-events and registration. As the founder of a .Net user group www.mainebytes.org , I attended the iNeta User Group Leaders summit. It was well done with a lot of information to the user group leaders on how to make their groups…


HowTo: Create a SmartTag in VB or C# in less than 10 lines of code

Creating SmartTags for Word and Excel using VSTO 2005 has become incredibly simple. I will show you how to create a SmartTag that interacts with an ActionsPane in less than 10 lines of code, including adding the ActionsPane. One of the hardest things to do in Office development has now become one of the easiest….