Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Yuri Rubinov
  Where is Yuri Rubinov?
 Philadelphia
 Pennsylvania - United States
 Yuri Rubinov
 To: Cetin Basoz
  Where is Cetin Basoz?
 Izmir
 Turkey
 Cetin Basoz
 Tags
Subject: RE: Calling Auto subtotal Function in Excel
Thread ID: 228076 Message ID: 228664 # Views: 3 # Ratings: 0
Version: Visual FoxPro 9 Category: Microsoft Office Automation
Date: Wednesday, May 20, 2009 4:31:16 PM         
   


> > dimension atemp[1]
> > atemp[1] = INT(ia/6)+1 && number of expected groups
> >
> > .ActiveSheet.Range("A2:B11").Subtotal(1,xlSum, @atemp,.t.,.f.,.t.)
>
> I think there is a typo here.
>
>
aTemp[1] = 2 && Column(s) # to total

>
> Cetin Basoz
>
> .Net has got better.Think about moving - check my blog:
> Blog (main)
> Blog (mirror)

Cetin,

Thanks, my mistake.
aTemp[1] represent the number of data columns, not number of groups as I thought.

Muhammad,

Make a note of it.


Yuri Rubinov

ENTIRE THREAD

Calling Auto subtotal Function in Excel Posted by Muhammad Zahid @ 5/15/2009 8:00:02 AM
RE: Calling Auto subtotal Function in Excel Posted by Yuri Rubinov @ 5/15/2009 5:08:19 PM
RE: Calling Auto subtotal Function in Excel Posted by Muhammad Zahid @ 5/20/2009 8:19:33 AM
RE: Calling Auto subtotal Function in Excel Posted by Yuri Rubinov @ 5/20/2009 3:32:14 PM
RE: Calling Auto subtotal Function in Excel Posted by Cetin Basoz @ 5/20/2009 3:57:07 PM
RE: Calling Auto subtotal Function in Excel Posted by Yuri Rubinov @ 5/20/2009 4:31:16 PM