Excel.dll question

[Guest]

Hello All,

I have excel version 11 currently referenced in my vb.net proj.
I have created an excelsheet using Excel.Worksheet.

When I look at the available functions, such as insert i get
Insert([Shift as Object], [CopyOrigin as Object])

I was wondering where can I look to find valid values for both [Shift] and
[CopyOrigin] variables and other variables that are used with excel functions.

Thank you for any information that you may provide.
E-Cube

 

[Paul Clement]

¤ Hello All,
¤
¤ I have excel version 11 currently referenced in my vb.net proj.
¤ I have created an excelsheet using Excel.Worksheet.
¤
¤ When I look at the available functions, such as insert i get
¤ Insert([Shift as Object], [CopyOrigin as Object])
¤
¤ I was wondering where can I look to find valid values for both [Shift] and
¤ [CopyOrigin] variables and other variables that are used with excel functions.
¤
¤ Thank you for any information that you may provide.
¤ E-Cube

Try the Excel object model documentation:

http://msdn.microsoft.com/library/d...n-us/vbaxl11/html/xlmthInsert1_HV03076822.asp


Paul
~~~~
Microsoft MVP (Visual Basic)

 

[Guest]

sweet just what I was looking for thanks a bunch