Changing object fill pattern in Excel

T

theBruceGuy

I am trying to change the Legendkey object in excel from an Access database.

Everything works correctly except the line:

xlApp.ActiveChart.Legend.LegendEntries(5).LegendKey.Fill.Patterned
Pattern:=msoPatternDarkHorizontal

It appears that it doesn't like any of the mso pattern types. How can I
accomplsih the change?
 
Top