Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel Subtotals
Message
From
20/03/2000 17:27:17
Todd Brown
Teachers Credit Union
Granger, Indiana, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
ActiveX controls in VFP
Title:
Excel Subtotals
Miscellaneous
Thread ID:
00348141
Message ID:
00348141
Views:
46
I am trying to create subtotals in Excel with multiple columns being subtotaled. I am unclear on how to use Excel arrays in Foxpro.

EXCEL HELP:
expression.Subtotal(GroupBy, Function, TotalList, Replace, PageBreaks, SummaryBelowData)

MY CODE:
oSheet = CreateObject("Excel.Application")
oSheet.workBooks.Open("C:\data\cob7\tmpmbr.xls")
oSheet.Selection.Subtotal (1, -4157,3)

With my code, the third column is subtotaled correctly. How would I subtotal both column three and four.
Reply
Map
View

Click here to load this message in the networking platform