Help with Excel control with VB.Net

  • Thread starter Thread starter Dan
  • Start date Start date
D

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(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 select
the multiple objects at once in order to group them.

any help would be appretiated
thanks

Dan
(e-mail address removed)
 
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 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
Click to expand...
("Border", "BackGround", "Price" _
 
Back
Top