Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sorting in Excel
Message
 
 
To
26/10/2009 15:26:11
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2003 Server
Database:
MySQL
Application:
Desktop
Miscellaneous
Thread ID:
01431570
Message ID:
01431573
Views:
34
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform