Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sort a range in excel
Message
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
01062883
Message ID:
01062888
Views:
15
What error are you getting? Is xlDescending defined? If not use this:
#DEFINE xlDescending	2	
>Hello,
>
>Is there someone who can help me out with a excel sorting problem?
>
>I have a excel sheet i acces from Fospro.
>The data is read from a fox table and put in a sheet.
>Now i want to sort a range in excel descending but i allways get an error.
>
>My code of line is:
>
> oWorkBook.ActiveSheet.Range("A17:C36").Sort Key1.Range("C18").Order1=xlDescending
>
>Can anybody please solve my problem?
>
>
>Thanks
>ad
Previous
Reply
Map
View

Click here to load this message in the networking platform