Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel Automation - Sort
Message
 
To
01/11/2001 14:37:54
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00576343
Message ID:
00576368
Views:
24
Try:
with objExcel
.Selection.Sort(.Activesheet.Range("B1"), .Activesheet.Range("C1"))
endwith

>I'm trying to sort all the data in an Excel spreadsheet from a VFP 6 program with this command:
>
>.CurrentRegion.Sort Key1:=Range("B1"),Key2:=Range("C1")
>
>My other Excel commands are working, but this one is giving me a syntax error and my guessing of variations haven't worked.
>
>Any clues?
>
>Also, do you know of any good documentation on command syntax for working with Excel from VFP, other than "Microsoft Office Automation with Visual FoxPro"?
Previous
Reply
Map
View

Click here to load this message in the networking platform