Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Subtotal in excel
Message
From
28/07/2014 07:04:05
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Title:
Subtotal in excel
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01604802
Message ID:
01604802
Views:
43
I thought this code would subtoal on column 5, but it doesn't
what do I do wrong??
#include  excel10.h
 
....

.....



oExcel.selection.PasteSpecial()

DIMENSION la1[1]

la1[1]= 5    &&&& subtotla column 5

oexcel.Subtotal(1, xlSum,@la1,-1,-1,-1)

oExcel.ActiveSheet.Outline.ShowLevels(3)
Peter Cortiel
Reply
Map
View

Click here to load this message in the networking platform