Office Programming Model
A reader writes: I've enjoyed reading your online blog about Excel/Dotnet integration. I have a question, that if anyone would know the answer to, hopefully you do. Is there any trick that can be used to speed up insertion of large blocks of data into
Read More...
VSTO takes a very strong stance on security to prevent the spread of macro viruses or worms. VSTO's security model involves the trust of two things: 1) the assembly associated with the document must be trusted and 2) the location the document is coming
Read More...
Visual Studio Tools for Office is really taking off and the team that creates VSTO is growing fast. If you are interested in working at Microsoft and helping us build tools to help developers build customizations for Office, please check out this list
Read More...
Kathleen has just posted two new videos showing how VSTO's Data Binding Features work. I guarantee you'll be wowed by these videos. The first shows the creation of a databound list and controls in Excel created by simply dragging and dropping. The second
Read More...
If you haven't checked it out yet, Chris Kunicki has created a VSTO Zone at his site that has a bunch of useful information about VSTO: http://www.officezealot.com/vsto/ Also, Kathleen has posted some more VSTO video tutorials: Demo 5--How to Resize Excel
Read More...
Items in a Word collection are accessed in two different ways depending on whether the index into the collection is strongly typed or weakly typed. In the case of the KeyBindings collection for example, the index is strongly typed as an integer. As such,
Read More...
I've updated this article with some new guidance-- for the details, see this post . Excel enables the creation of user defined functions that can be used in Excel formulas. A developer must create a special kind of DLL called an XLL. Excel also allows
Read More...
This seems like a reasonable piece of code: For Each oCell As Excel.Range In Me.Range("a1:b5") oCell.Value = "test" Next so does this: foreach Excel.CustomProperty prop in worksheet.CustomProperties { Console.WriteLine(prop.Name); } Unfortunately, when
Read More...
Kathleen has created two new videos you should check out. Nice! Demo 5--How to Resize Excel Controls D e mo 6 - How to Add Controls to the Actions Pane
Read More...
[EDITOR'S NOTE] Blogging has been slow as we are spending almost all our time getting Beta 2 out the door. You may have had the experience of Excel or Word causing an Office Watson error at debug time when you have an exception that occurs in your Windows
Read More...
I've been doing some C# development with the Excel object model and when you look at Excel objects in the object browser or in intellisense there are two major problems you run into: 1) Methods that would be hidden in VBA are shown in the object browser
Read More...
This is a frequent question that comes up. You develop a managed add-in or VSTO 2003 code behind. You show a windows form and yuck--it looks like Windows XP never happened. The buttons aren't pretty like the Windows XP buttons. Everything looks circa
Read More...
If you haven't had a chance yet to see these great videos that Kathleen has made of VSTO in action, check them out. They're each about 6 minutes long are are really nice glimpses into some of the cool features of VSTO 2005. Keep 'em coming Kathleen! Demo
Read More...
I recently posted some code showing how to get Outlook to shut down. I contended that you shouldn't have to call ReleaseCOMObject as is shown in some MSDN articles to get Outlook to shut down. Indeed, David Mortenson who has worked on interop here at
Read More...
Another new article on MSDN about VSTO 2005 --this time by J. Jason De Lorme. Jason mentions that VSTO 2005 doesn't support complex databinding against XMLNodes. We did add an "UpdateXML" method (renamed to LoadXML in Beta 2) on an XMLNode that should
Read More...
