Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Line Weight Property
Message
 
To
23/05/2002 05:10:46
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00660311
Message ID:
00660353
Views:
8
Ger,

>I have a line on an excel worksheet but I want to change the
>thickness of the line. How can this be done in VFP?
>


If You use the Borders of the cells it can be done like
that:
   #define xlHairline       1
   #define xlContinuous     1
   #define xlHAlignCenter   -4108
    ....

    with .Range(.Cells(ln_Row, 1), .Cells(ln_Row, pn_MaxCols))
        .Borders.LineStyle     = xlContinuous      && Durchgezogener Rahmen
        .Borders.Weight        = xlHairLine
        .Interior.Color        = pn_HeaderColor    && helles Gelb
        .HorizontalAlignment   = xlHAlignCenter    && Zentrieren
    endwith
HTH
Regards from Berlin

Frank

Dietrich Datentechnik (Berlin)
Softwarekombinat Teltow (Teltow)

Frank.Dietrich@dd-tech.de
DFPUG # 327
Previous
Reply
Map
View

Click here to load this message in the networking platform