Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Sorting in Excel
Message
 
 
À
26/10/2009 15:26:11
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2003 Server
Database:
MySQL
Application:
Desktop
Divers
Thread ID:
01431570
Message ID:
01431573
Vues:
35
>Hello all,
>
>I try to translate excel macro to VFP code. Everythink work perfect for me except one command.
>Can somebody help me how to translate following VBA command to VVP?
>
>ActiveWorkbook.Worksheets("Sheet1").Sort.SortFields.Add Key:=Range("B6:AC6") _
> , SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:=xlSortNormal
>
>I have no problem with passing parameters from FoxPro to Sort.SortFields.Ad method
>except one - Key:=Range("B6:AC6"). How can I create RANGE variable in FoxPro and
>how can I pass it to Excel?
>
>Thanks in advance
>Maroš Klempa

Samples of using lcRange as a variable

Re: VFP2Excel problem Thread #1385377 Message #1385518

Re: Saveas: do not keep incomp. functions, do not keep chang Thread #1243150 Message #1243237
If it's not broken, fix it until it is.


My Blog
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform