Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Moving columns in Excel programmatically
Message
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 8
OS:
Windows XP
Network:
Windows 2000 Server
Database:
Visual FoxPro
Divers
Thread ID:
01507161
Message ID:
01507201
Vues:
54
Is there anything you don't know? ;-) Keep up the great work.


>Those are Excel constants and you can use VFP Object browser to get them. You also have to convert named parameters to position based. Something like
>
>
>#DEFINE xlShiftDown -4121
>#DEFINE xlShiftToLeft -4159
>#DEFINE xlShiftToRight -4161
>#DEFINE xlShiftUp -4162
>
>oRange = oSheet.Columns("G")
>oRange.Cut()
>oRange2 = oSheet.Columns("B")
>oRange2.Insert(xlShiftToRight) 
>
>
>>How may I move a column in Excel programmatically? Code in macro doesn't work properly in VFP.
>>
>>Columns("BC:BC").Select
>>Selection.Cut
>>Range("C1").Select
>>Selection.Insert Shift:=xlToRight
>>
>>"Insert Shift" nor "xlToRight" are not recognized by VFP.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform