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.