Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sort a range in excel
Message
From
28/10/2005 08:13:47
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
28/10/2005 05:30:00
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
01062883
Message ID:
01062906
Views:
15
Search for "constants" in the download section; there is a .H file that contains all the relevant constants.

Groeten,

Hilmar.

>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
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Reply
Map
View

Click here to load this message in the networking platform