Help with Excel control with VB.Net

[Dan]

Hi guys,

I'm trying to automate an excel worksheet through vb.net. So far i've been
able to figure everything out. However, i recently ran into a problem. I can
ungroup of set of objects with no problem. However, i can't figure out how
to regroup them.

Using excel the grouping command would be
ActiveSheet.Shapes.Range(Array("Border", "BackGround", "Price" _
, "Sku", "Name", "Desc",
"Misc", "Picture")).Select
Selection.ShapeRange.Group.Select

in vb.net i tried:

objBook.Sheets("Print").ActiveSheet.Shapes.Range(A rray("Border",
"BackGround", "Price" _

, "Sku", "Name", "Desc", "Misc", "Picture")).Select()
objapp.selection.ShapeRange.Group.Select

it tells me that array cannot be used. I can't figure out how else to select
the multiple objects at once in order to group them.

any help would be appretiated
thanks

Dan
Ba********@hotmail.com

[dermot]

try Excel.Array or something like that, ie use the Excel
definition of array rather than the VB.Net version

-----Original Message-----
Hi guys,

I'm trying to automate an excel worksheet through vb.net. So far i've beenable to figure everything out. However, i recently ran into a problem. I canungroup of set of objects with no problem. However, i can't figure out howto regroup them.

Using excel the grouping command would be
ActiveSheet.Shapes.Range(Array ("Border", "BackGround", "Price" _ , "Sk u", "Name", "Desc","Misc", "Picture")).Select
Selection.ShapeRange.Group.Select

in vb.net i tried:

objBook.Sheets("Print").ActiveSheet.Shapes.Range( Array ("Border","BackGround", "Price" _

, "Sku", "Name", "Desc", "Misc", "Picture")).Select()
objapp.selection.ShapeRange.Group.Select

it tells me that array cannot be used. I can't figure out how else to selectthe multiple objects at once in order to group them.

any help would be appretiated
thanks

Dan
Ba********@hotmail.com
.