G
Guest
Any ideas why the chart fill won't accept RGB colour values? Despite MSDN
saying a FillFormat should....
http://msdn2.microsoft.com/en-us/library/Aa173295(office.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.
saying a FillFormat should....
http://msdn2.microsoft.com/en-us/library/Aa173295(office.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.