| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Documentation of Excel 2003 objects
I'm starting to learn how to use C# with Excel 2003 but I cannot find the
detailed documentation of some of the objects. For example I have seen many code examples which include a Range object property named Value2 and a Worksheet method get_Range() but I have been unable to find a formal definition of the Range and Worksheet objects which includes these properties. Can someone please tell me where to look. Code examples are OK as an introduction but definitions of all classes and objects as in .Net are necessary, are they not? Ken |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Documentation of Excel 2003 objects
The Excel VBA help file. Also, the object browser in Excel VBA.
-- Regards, Tom Ogilvy "Ken Ellis" wrote in message ... I'm starting to learn how to use C# with Excel 2003 but I cannot find the detailed documentation of some of the objects. For example I have seen many code examples which include a Range object property named Value2 and a Worksheet method get_Range() but I have been unable to find a formal definition of the Range and Worksheet objects which includes these properties. Can someone please tell me where to look. Code examples are OK as an introduction but definitions of all classes and objects as in .Net are necessary, are they not? Ken |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Documentation of Excel 2003 objects
No Tom, nothing in there for Value2 or get_Range. I couldn't even find a
reference to a Range Object as such: plenty of details for Range as a property but not for it as an object. Ken "Tom Ogilvy" wrote in message ... The Excel VBA help file. Also, the object browser in Excel VBA. -- Regards, Tom Ogilvy "Ken Ellis" wrote in message ... I'm starting to learn how to use C# with Excel 2003 but I cannot find the detailed documentation of some of the objects. For example I have seen many code examples which include a Range object property named Value2 and a Worksheet method get_Range() but I have been unable to find a formal definition of the Range and Worksheet objects which includes these properties. Can someone please tell me where to look. Code examples are OK as an introduction but definitions of all classes and objects as in .Net are necessary, are they not? Ken |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Documentation of Excel 2003 objects
From help on Value2:
Returns or sets the cell value. Read/write Variant. Remarks The only difference between this property and the Value property is that the Value2 property doesn't use the Currency and Date data types. You can return values formatted with these data types as floating-point numbers by using the Double data type. -- Regards, Tom Ogilvy "Ken Ellis" wrote in message ... No Tom, nothing in there for Value2 or get_Range. I couldn't even find a reference to a Range Object as such: plenty of details for Range as a property but not for it as an object. Ken "Tom Ogilvy" wrote in message ... The Excel VBA help file. Also, the object browser in Excel VBA. -- Regards, Tom Ogilvy "Ken Ellis" wrote in message ... I'm starting to learn how to use C# with Excel 2003 but I cannot find the detailed documentation of some of the objects. For example I have seen many code examples which include a Range object property named Value2 and a Worksheet method get_Range() but I have been unable to find a formal definition of the Range and Worksheet objects which includes these properties. Can someone please tell me where to look. Code examples are OK as an introduction but definitions of all classes and objects as in .Net are necessary, are they not? Ken |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Documentation of Excel 2003 objects
Thanks Tom, but where is the information you gave me formally documented?
There are a host of methods such as get_Range and set_Value which I have seen used in examples but I don't know where to find the details. Best Wishes Ken "Tom Ogilvy" wrote in message ... From help on Value2: Returns or sets the cell value. Read/write Variant. Remarks The only difference between this property and the Value property is that the Value2 property doesn't use the Currency and Date data types. You can return values formatted with these data types as floating-point numbers by using the Double data type. -- Regards, Tom Ogilvy "Ken Ellis" wrote in message ... No Tom, nothing in there for Value2 or get_Range. I couldn't even find a reference to a Range Object as such: plenty of details for Range as a property but not for it as an object. Ken "Tom Ogilvy" wrote in message ... The Excel VBA help file. Also, the object browser in Excel VBA. -- Regards, Tom Ogilvy "Ken Ellis" wrote in message ... I'm starting to learn how to use C# with Excel 2003 but I cannot find the detailed documentation of some of the objects. For example I have seen many code examples which include a Range object property named Value2 and a Worksheet method get_Range() but I have been unable to find a formal definition of the Range and Worksheet objects which includes these properties. Can someone please tell me where to look. Code examples are OK as an introduction but definitions of all classes and objects as in .Net are necessary, are they not? Ken |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Documentation of Excel 2003 objects
From help on Value2:
The Excel VBA help file. never heard of get_Range or set_Value. That must be something from C# -- Regards, Tom Ogilvy "Ken Ellis" wrote in message ... Thanks Tom, but where is the information you gave me formally documented? There are a host of methods such as get_Range and set_Value which I have seen used in examples but I don't know where to find the details. Best Wishes Ken "Tom Ogilvy" wrote in message ... From help on Value2: Returns or sets the cell value. Read/write Variant. Remarks The only difference between this property and the Value property is that the Value2 property doesn't use the Currency and Date data types. You can return values formatted with these data types as floating-point numbers by using the Double data type. -- Regards, Tom Ogilvy "Ken Ellis" wrote in message ... No Tom, nothing in there for Value2 or get_Range. I couldn't even find a reference to a Range Object as such: plenty of details for Range as a property but not for it as an object. Ken "Tom Ogilvy" wrote in message ... The Excel VBA help file. Also, the object browser in Excel VBA. -- Regards, Tom Ogilvy "Ken Ellis" wrote in message ... I'm starting to learn how to use C# with Excel 2003 but I cannot find the detailed documentation of some of the objects. For example I have seen many code examples which include a Range object property named Value2 and a Worksheet method get_Range() but I have been unable to find a formal definition of the Range and Worksheet objects which includes these properties. Can someone please tell me where to look. Code examples are OK as an introduction but definitions of all classes and objects as in .Net are necessary, are they not? Ken |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 drawing objects problems in Excel 2007... | Excel Discussion (Misc queries) | |||
| excel 2003 subtotals cannot shift objects from sheet | Excel Discussion (Misc queries) | |||
| Fixed objects will move warning in excel 2003 | Excel Discussion (Misc queries) | |||
| Fixed objects will move warning in excel 2003 | Excel Worksheet Functions | |||
| why does Excel 2003 flip picture objects in a document created in. | Excel Discussion (Misc queries) | |||
![Ken Ellis[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
