I Heart VBA Macros

Today at TechEd we launched a new MSDN developer site dedicated to creating VBA Office Macros. Go to www.iheartmacros.com to get started. The site contains tools and resources for tech savvy users and beginners to get going creating powerful Office applications. Developer Atlas Check out the interactive Silverlight based learning tool.


How to get a copy of Office 2010 technical preview

More details have been coming out of TechEd 2009 this week. One of the cool announcements is that the Office 2010 technical preview is just around the corner. This will be closed release. If you were lucky enough to go to TechEd you are first in line. But there is still hope for the rest…


Office tip: Word Format Painter gets sticky

The Format Painter feature in Office is one on my favorite features. If you are not familiar with this feature it allows you to apply formatting to text based on the format of some other text in your document. I use this feature a lot while writing specs. The spec template that we use is…


VSTO: My Favorite Feature – ClickOnce Deployment

One of my favorite features in the latest version of VSTO is ClickOnce Deployment. ClickOnce deployment makes securely deploying my Office add-in and document level solutions easy. VSTO deployment supports, Local, HTTP, UNC, CD/DVD and USB locations. This gives you the flexibility to deploy your application where it makes sense for you.  Deployment also supports offline,…


Top 20 cool new features of VSTA

Now that VSTA has RTM’d (See KD Hallman’s announcement at http://blogs.msdn.com/vsta ) I would like to call out all of the great features of VSTA. You can see some of these features in action today as part of InfoPath 2007. Just install InfoPath 2007, open a form and press Alt-Shift-F12. The VSTA IDE will open…


New VSTO team member blog

After all of this time Kathleen McGrath who is member of the VSTO team and has been responsible for most of the VSTO team blog posts has finally started her own blog.http://blogs.msdn.com/Kathleen/ . Kathleen has been doing a lot of great work in her spare time creating video tutorials for the team site and Channel…


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…


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….


Attaching custom properties to your VSTO 2005 SmartTag

VSTO 2005 makes attaching custom properties to a Smart Tag easy. These properties can be used by the Smart Tag action. See my previous post VSTO 2005 makes Smart Tags smarter (and easier) to learn how to create VSTO SmartTags. Let’s image that you are creating a VSTO Word document for a large insurance company….


Create Watermarks using VSTO 2005 (Part 2 C#)

In my blog yesterday I showed How to create a Word Watermark using VSTO 2005. This was relatively easy to do using VB .Net. Today I will show you the same code using VSTO 2005 and C# (for those of you who like abuse). I have tried to make the code exactly the same as…