Unable to get the Interior property of the PlotArea class

Hi,
I'm using Microsoft.Office.Interop.Excel and VB.Net with ASP.Net to
create an Excel workbook with an Excel chart in a worksheet. Most of
the code works that I developed in VBA. The chart is created. But, it
fails to find any properties or methods of the PlotArea class. Even
though they are "available" in the context menu.

This line works:
xlApp.ActiveChart.ChartArea.Border.LineStyle = 0

But this fails:
xlApp.ActiveChart.PlotArea.Interior.ColorIndex = xlNone
with the error message "Unable to get the Interior property of the
PlotArea class"

(xlNone is a constant)

Has anyone run into a similar problem?

Thanks,
Wendell

When you run that line does the chart actually have a PlotArea. It wouldn't
for example if no series had yet been added to the chart or if all series
had been deleted.

Regards,
Peter T

<wendell_lucas.DeleteThis@hotmail.com> wrote in message
news:d4a930d7-f08f-492e-92c7-5a1ab0c329a6@k37g2000hsf.googlegroups.com...
> Hi,
> I'm using Microsoft.Office.Interop.Excel and VB.Net with ASP.Net to
> create an Excel workbook with an Excel chart in a worksheet. Most of
> the code works that I developed in VBA. The chart is created. But, it
> fails to find any properties or methods of the PlotArea class. Even
> though they are "available" in the context menu.
>
> This line works:
> xlApp.ActiveChart.ChartArea.Border.LineStyle = 0
>
> But this fails:
> xlApp.ActiveChart.PlotArea.Interior.ColorIndex = xlNone
> with the error message "Unable to get the Interior property of the
> PlotArea class"
>
> (xlNone is a constant)
>
> Has anyone run into a similar problem?
>
> Thanks,
> Wendell