Prev: Unable to open links from Excel in new tab - keeps opening new
Next: signing VBA Macros for Excel
From: Fabz on 8 Mar 2010 04:52
I just stumbled upon this. In the book "Visual Studio Tools for Office 2007"
(Eric Carter, Eric Lippert) the authors write:

"In C#, you must pass a special value to optional parameters that are of
type object if you do not want to specify the parameter. This special value
is called System.Type.Missing, and it must be passed for optional parameters
that you do not want to specify directly (unlike Visual Basic in which oyu
can omit the parameter entirely). In VSTO projects, a "missing" variable is
predeclared for you (that is set to System.Type.Missing). Therefore, VSTO
code, you will often see missing pased rather than System.Type.Missing."

Doesn't exactly answer my question, but since the two guys seem to form part
of MS's developer team, they certainly know why they recommend doing it this
way.
Fabz


"Fabz" <fabian.kostadinov(a)wsl.ch> wrote in message
news:eN1msaWfKHA.1648(a)TK2MSFTNGP05.phx.gbl...
> When I want to call an Excel-Worksheetfunction from my C# AutomationAddIn
> which takes many parameters (such as SUM), in which case should I use
> Type.Missing for the missing parameters and in which case should I use
> System.Reflection.Missing.Value instead? Is there a difference in
> functionality or performance? I've come across both.
>
> Fabz
>


 | 
Pages: 1
Prev: Unable to open links from Excel in new tab - keeps opening new
Next: signing VBA Macros for Excel