I need to change the fill of a data series in an area chart using a VBA macro. The fill is a picture file. Also the fill must be set to "Tile".

I expected something like this but it does not work:

ActiveChart.SeriesCollection(1).ChartType = xlArea
ActiveChart.SeriesCollection(1).Interior.UserPictu re "c:\green.bmp"
ActiveChart.SeriesCollection(1).Interior.TextureTi le.True

Hope you can help me.

There is no interior property.
If I remember correctly, this should do what you want:
ActiveChart.SeriesCollection(1).Fill.UserPicture "c:\green.bmp"
ActiveChart.SeriesCollection(1).Fill.TextureTile = True