Another excel question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I convert this VBA script into VB.Net?

Rows("4:5").Select
Selection.Rows.group

I did take a look at the office 2003 sdk for excel at the group property but
that did not provide helpful information.

Any information is appreciated?

E-Cube
 
I found that setting the Outlinelevel property appropiately would allow me to
mimic the functionality of the vba script I entered in my previous post.
 
How do I convert this VBA script into VB.Net?
Rows("4:5").Select
Selection.Rows.group

I did take a look at the office 2003 sdk for excel at the group property
but
that did not provide helpful information.

How is this VB.NET program running? Is it been called from Excel or invoking
Excel itself?

Rob.
 
Rob,

I have a reference to the excel.dll in vb.net.
I found that setting the outline level on the row Item to a certain value is
similar to the group method that is the vba script.

Thank you for any information
E-Cube
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top