General information
Category:
COM/DCOM and OLE Automation
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
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