General information
Category:
COM/DCOM and OLE Automation
Title:
Passing arrays to Excel
I'm trying to convert an Excel macro for calculating subtotals to VFP. The VB syntax is :
Selection.SubTotal GroupBy:=3, Function:=xlSum, TotalList:=array(11,12) Replace:=True, PageBreaks:=False, SummaryBelowData:=True
My VFP syntax, which isn't working, is:
.selection.subtotal(3,-4157,laList,.t.,.f.,.t.)
Any suggestions?
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only