In my previous post I wrote this--but then removed it: "Note that the Office XP PIAs will work against either Office XP or Office 2003. This is because the PIAs are backed by the COM object models of Office that are versioned in such a way that the OM...

This has become a frequently asked question--where are the Office PIAs? The Office XP PIAs are available here: http://www.microsoft.com/downloads/details.aspx?FamilyId=C41BD61E-3060-4F71-A6B4-01FEBA508E52&displaylang=en The Office 2003 PIAs are available...

Just when I thought it was safe to write .NET code in Excel, Mohit Gupta and Eric Lippert opened up for me a whole new world of horrible world of dates in Excel. Mohit recently added code similar to this snippet to our code tree to convert Excel dates...

[Editor's note] I've been on leave from Microsoft but I'm back now so postings should be more frequent again. In VSTO 2.0 you can create a named range on a worksheet and write code behind that named range. Say you have a sheet called Sheet1 that has a...