Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sorting in Excel
Message
From
27/10/2009 17:50:45
Maros Klempa
Protherm s.r.o.
Skalica, Slovakia
 
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Title:
Re: Sorting in Excel
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2003 Server
Database:
MySQL
Application:
Desktop
Miscellaneous
Thread ID:
01431570
Message ID:
01431773
Views:
40
Bingo,

that's what I searched for.
Only small modification and it works:
ActiveWorkbook.Worksheets("Sheet1").Sort.SortFields.Add(oExcel.Range("B6:AC6"), , , , , , xlSortOnValues, xlAscending, xlSortNormal)

Thanks a lot
Previous
Reply
Map
View

Click here to load this message in the networking platform