Excel’s Worksheets and Sheets Collection – What’s the Difference?

Among the top four objects most searched for on the Microsoft Developer Network by Excel programmers are the Sheets collection and the Worksheets collection (the other two are the Range object and the Application object). As an aside, I’ve written new articles on programming the Range and Application objects which will be published on the Office…

0

Check out these new articles on MSDN

The article Calling Excel 2007 Custom Wizards from the Office Fluent Ribbon by Using VBA (http://msdn2.microsoft.com/en-us/library/bb927654.aspx) demonstrates how to create a custom wizard in  Excel 2007 using VBA and then modify the Ribbon to call the wizard. Albert Raiani does a great job in explaining how to trigger custom code when you drag data from…

1

Cool translation feature in Microsoft Office

One of the coolest features in Office that I think many people (well, at least me) overlook is the translation capability. You can type in a word and get a translation immediately in any language you select. I’m currently trying to teach myself Spanish and find this feature really useful. http://frice.officeisp.net/Miscellaneous%20pictures/OfficeTranslationFeature.gif In most Office 2007 applications,…

0

Using Code Snippets in Visual Studio 2005 is Incredible

Visual Studio 2005 code snippets are a neat way to package pieces of code that you want to keep close at hand. These can be code samples that you’ve created or samples that you find during searches. And creating them is pretty easy with some of the free editors that are available. Such as: Visual…

0

New Visual How-to content on the Microsoft Office Developer Center

Just a quick note to say that there is new developer content on the Office Developer Center (http://msdn2.microsoft.com/en-us/office/default.aspx). These include over one hundred Ribbon code snippets that can be dropped into Visual Studio solutions. About half have been written in Visual Basic .NET and the other half werer written in C#. There are samples that target…

0