Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Horizontal Alignment in Excel?
Message
From
14/07/2009 19:27:02
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
14/07/2009 19:19:16
General information
Forum:
Visual FoxPro
Category:
ActiveX controls in VFP
Environment versions
Visual FoxPro:
VFP 7
OS:
Windows XP SP2
Miscellaneous
Thread ID:
01412369
Message ID:
01412374
Views:
57
>It looks like...
>
>Sub Macro1()
>'
>' Macro1 Macro
>' Macro recorded 7/14/2009 by Martha Kroll
>'
>
>'
> With Selection
> .HorizontalAlignment = xlLeft
> .VerticalAlignment = xlBottom
> .WrapText = False
> .Orientation = 0
> .AddIndent = False
> .IndentLevel = 0
> .ShrinkToFit = False
> .ReadingOrder = xlContext
> .MergeCells = False
> End With
>End Sub

If you have some object that refers to a worksheet, the relevant part would be, in VFP:
loSheet(lnRow, lnCol).HorizontalAlignment = xlLeft
xlLeft is a constant understood by VBA, but not (initially) by Visual FoxPro. It is easiest to search in the download section, for "Excel constants", and include the file provided.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform