When foreach in Excel goes wrong

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 you run this code you will get a “Missing member” exception.  Some collections in Excel can’t be “for-eached” over.  To do “foreach” the CLR has to…

3

More VSTO 2005 Video Magic

Kathleen has created two new videos you should check out.  Nice! Demo 5–How to Resize Excel Controls Demo 6 – How to Add Controls to the Actions Pane

1

Office Watsoning and Exceptions in VSTO 2005 Beta 1

[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 Forms event handlers in VSTO 2005. The…

0