PC Review


Reply
Thread Tools Rate Thread

Another excel question

 
 
=?Utf-8?B?RS1DdWJl?=
Guest
Posts: n/a
 
      14th Mar 2005
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
 
Reply With Quote
 
 
 
 
=?Utf-8?B?RS1DdWJl?=
Guest
Posts: n/a
 
      14th Mar 2005
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.

"E-Cube" wrote:

> 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

 
Reply With Quote
 
Rob Nicholson
Guest
Posts: n/a
 
      19th Mar 2005
> 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.


 
Reply With Quote
 
=?Utf-8?B?RS1DdWJl?=
Guest
Posts: n/a
 
      21st Mar 2005
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

"Rob Nicholson" wrote:

> > 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.
>
>
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 Macro/VB Question DDE Question MadDog22 Microsoft Excel Discussion 13 12th Mar 2010 07:08 PM
Excel 2007 Macro/VB Question DDE Question MadDog22 Microsoft Excel Worksheet Functions 1 10th Mar 2010 01:47 AM
Excel 2007 Macro/VB Question DDE Question MADDOG22 Microsoft Excel Discussion 0 24th Feb 2010 02:23 AM
Math involved. Excel speed optimization question. UDF vs. longer excel equation Abe Microsoft Excel Programming 6 5th Jul 2006 03:17 PM
The question is an excel question that I need to figure out howto do in excel. Terry Microsoft Excel Worksheet Functions 3 23rd Jan 2006 06:22 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:17 AM.