How to create Style.Interior.Gradient property

[Raja]

In msdn library, i found that Interior object has two method :
1. OneColorGradient http://msdn.microsoft.com/en-us/library/bb256327.aspx
2. TwoColorGradient http://msdn.microsoft.com/en-us/library/bb256330.aspx

but i couldn't find them in Excel Inteop

Any ideas?

Regards,
Raja

 

[Sheeloo]

I think One of them is available only in Excel 2007...

Found the following in Excel 2003 Help
_______________________________________________
With Charts(1).ChartArea.Fill
.Visible = True
.ForeColor.SchemeColor = 15
.BackColor.SchemeColor = 17
.TwoColorGradient msoGradientHorizontal, 1
End With

_______________________________________________

 

[JLGWhiz]

In the VB editor for Excel help files, look for Gradient. That will bring up
any propeties that apply to color gradients. I believe they all apply to
either charts or shape objects.