Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Databars In Excel 2007
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Title:
Databars In Excel 2007
Miscellaneous
Thread ID:
01446196
Message ID:
01446196
Views:
77
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
Next
Reply
Map
View

Click here to load this message in the networking platform