Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Databars In Excel 2007
Message
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Titre:
Databars In Excel 2007
Divers
Thread ID:
01446196
Message ID:
01446196
Vues:
76
Hi all
I am trying to "translate" the VBA created by a macro in Excel 2007 to produce DataBars.
However I am running into problems on the MinPoint & MaxPoint lines
   Range("B4:B8").Select
    With Selection.FormatConditions(1)
        .MinPoint.Modify newtype:=xlConditionValueLowestValue
        .MaxPoint.Modify newtype:=xlConditionValueHighestValue
    End With
    With Selection.FormatConditions(1).BarColor
        .Color = 8700771
        .TintAndShade = 0
    End With
Any ideas how these can be represented in Foxpro?
TIA
Kevin
Kevin Delaney
Financial Systems Manager
CPL Solutions Ltd

83 Merrion Square, Dublin 2, Ireland.
e: kevin.delaney@cpl.ie w: www.cpl.ie
p: +353 1 482-5368
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform