Hello.

I’ve been working on a project, and had fantastic success with the search feature the last few days – I was able to find answers for everything I was looking for (and I even gave good rep to the people that posted the answers I was looking for). But now I’m stuck, and I need a little help.

I have an Excel file that I’m working with via .NET. One of the tabs is a chart – which I understand is actually a chart sheet (the entire tab is a big chart, with no cells).

I can open the Excel file:

Code:
Dim xExcelApp As New Excel.Application
xExcelApp.Workbooks.Open("C:\test.xls")
My problem is with the chart sheet. I want to select the chart, and then copy it (so I can paste it somewhere else). No matter what I try, I can’t seem to select the chart in the chart sheet:

Code:
xExcelApp.Workbooks(1).Worksheets("Report4_Chart").select()
xExcelApp.Selection.Copy()
Any ideas on what I’m doing wrong?
.