Excel and Visual Basic

[jwagus]

I am using Visual Basic to manipulate Excel. In the code, I am trying to activate a chart.

The code is:

MyExcel.Application.ActiveWorkbook.ActiveSheet.ChartObjects("Chart 3").Activate

The error that I get in VB is:

Unable to get the ChartObjects property of the Worksheet class.

I am doing a loop to find the number value for the object (i.e., the 3), when I encounter an error, I increment a counter until I find the object. After finding the right one, I am presented with this error above.

Any ideas as to what I am doing wrong?

 

[rikrak]

Hi,

I don't like counting errors, but will this give you what you are after?<pre>
Sub getnum()
Dim chrt As ChartObject
For Each chrt In ActiveWorkbook.ActiveSheet.ChartObjects
If chrt.Name = "Chart 3" Then
num = chrt.Index
End If
Next
End Sub</pre>
This message was edited by rikrak on 2002-10-18 16:53

 

[jwagus]

I may not have been clear about my porblem.

My problem is not that I can't find the object (although that code is probably better than what I am using). The problem is that once I find it, I can't Activate the ChartObject.

 

[rikrak]

I have no idea, but this works for me:
Excel.Application.ActiveWorkbook.ActiveSheet.ChartObjects("Chart 3").Activate

Maybe someone else around here has the answer.

 

[stevebausch]

Record a macro of what you want to do. Study the macro's code.

 

[Legacy 98055]

Hi jw.
Please post the entire procedure. You may be creating an application object in a separate thread. This application object would have a separate collection of workbooks, sheets, ect...
Tom