Any ideas why the chart fill won't accept RGB colour values? Despite MSDN
saying a FillFormat should....
http://msdn2.microsoft.com/en-us/lib...ffice.11).aspx

An example:

--------------------------------------------
bRGB = false
With oBook.ActiveChart.PlotArea.Fill

if (bRGB) then
' This doesn't work
.ForeColor.RGB = RGB(128, 0, 0)
.BackColor.RGB = RGB(170, 170, 170)
else
' This works
.ForeColor.SchemeColor = 15
.BackColor.SchemeColor = 16
end if

.TwoColorGradient msoGradientHorizontal, 1
End With
--------------------------------------------

Setting bRGB to true results in: Wrong number of arguments or invalid
property assignment: 'ForeColor.RGB'

This is being called from an external VBScript, not within Excel, if that
makes a difference.

Am I misreading how this should work? Suggestions or workarounds welcome.
Thanks.