When programming in C#--if you want to omit an optional parameter for a method in the Excel object model, you have to pass System.Type.Missing to the parameter: myExcelApp.MethodWithOptionalParameter(System.Type.Missing); When you want to omit an optional
Read More...
An internal user of VSTO asks: Why can't we give an error message like "Visual Studio 2005 Tools for Office is not installed" instead of the meaningless ""The assembly * could not be found at or could not be loaded..."? The meaningless error message occurs
Read More...
In Beta2 we shipped with an unforunate bug that will affect VB.NET users. If you write code like this in a worksheet project item, it will fail with a COMException at runtime: MsgBox(Me.Range("A1").Value) The problem is that when you wrote the code Range("A1")
Read More...