>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

*** Assume that oExcel is your reference to Excel.Application
oExcel.Range("B4:B8").Select
With oExcel.Selection.FormatConditions(1)
     .MinPoint.Modify(1) && xlConditionValueLowestValue
     .MaxPoint.Modify(2) && xlConditionValueHighestValue
EndWith
With oExcel.Selection.FormatConditions(1).BarColor
     .Color = 8700771
     .TintAndShade = 0
EndWith

NOT TESTED!