>The way I do it is as follows:
>
> oXL.range("A1:A10").horizontalalignment=(-4131)
>
>I am not sure this is the best way, but if you go into excel and record a macro while you perform the operation, you can use the macro code with a bit of massaging in you VFP code. The only annoyance is EXCEL uses Constants in many cases, but if you step into the macro and go into debug mode, you can hover your mouse over the constants and the contants will reveal their values.
>
>
>>People ,
>>
>>I want to left-align a column in excel.I've tried to left-align the
>>column with horizontal-alignment but it doesn' t work.
>>any suggestions ,
>>
>>regards,
>>David van der vliet.
Also you can include the excel constant file, that can be found here on the UT, in your VFP program. That way you can use the constants just like in VBA. (Must of the time)
HTH
Jeff
It's Time to get a gun.
That's what I've been thinkin.
I think I can afford one, If I do a little less Drinkin.www.TrueGeeks.com