Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Type.Missing vs. System.Reflection.Missing.Value as WSF parameters?
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Type.Missing vs. System.Reflection.Missing.Value as WSF parameters?
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" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MISSING: ReportBuilderAddIn 1.0 Type Library | Excel Programming | |||
Missing system file in excel | Setting up and Configuration of Excel | |||
Missing Type Library | Excel Programming | |||
On Error? Creates 1 missing worksheet then never detects any other missing worksheets | Excel Programming | |||
MISSING:shappmgrp 1.0 Type Library | Excel Programming |