Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to left align a column in excel
Message
General information
Forum:
Visual FoxPro
Category:
Classes - VCX
Miscellaneous
Thread ID:
00245967
Message ID:
00246056
Views:
11
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform