Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to add Subtotal and Groupby ?
Message
 
To
08/07/2011 06:43:12
Yim Ming Sun Derek
Spacious Design Consultant
Hong Kong, Hong Kong
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2008
Miscellaneous
Thread ID:
01517672
Message ID:
01517673
Views:
54
>Hi,
>
>How to convert the EXCEL VBA code of the subtotal and groupby to VFP9 ?
>
>    Selection.Subtotal GroupBy:=1, Function:=xlSum, TotalList:=Array(3), Replace:=True, PageBreaks:=False, SummaryBelowData:=True
>
>
>
>Please advise.
>
>Thanks.


Open the VBA editor in Excel.
Mark Subtotal and press F1.
That will open Excel VBA help and you will see the positioned parameters, and will see how you could use this method in VFP.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform