excel 2007 from vba Access: name and select a chart 1

[aldi07]

Hi, I am trying to rename a chart in excel 2007 from vba access 2007, then access that chart from access 2007.
This is the code I am using:

With xlObj
.ActiveChart.Parent.Name = MyReportNo

 

[aldi07]

Sorry, I posted by hitting the wrong key. Here is the entire question:
Hi, I am trying to rename a chart in excel 2007 from vba access 2007, select a new location on the spreadsheet, then access that chart from access 2007 to place it in the new cell.
This is the code I am using:

With xlObj
.ActiveChart.Parent.Name = MyNewChartName
.Range(MyTargetChartPos).Select
.ActiveSheet.ChartObjects(MyNewChartName).Select
.Selection.Cut
.ActiveSheet.Paste
End With

When it reaches .ActiveSheet.ChartObjects(MyNewChartName).Select I get the error "Application-defined or object-defined error.

Could anybody tell me what I am doing wrong? (remember it is office 2007).

Thank you

 

[SkipVought]

'NEVER NEVER NEVER assume that the activeANYTHING will be what you expect!
'Explicitly reference all objects as a practice.
'assuming that xlObj is the Excel Application object
With xlObj.Sheets("Sheet Name Where Chart is")
'assuming that the first chartobject is the correct one...
    .ChartObjects(1).Name = MyNewChartName
    .ChartObjects(MyNewChartName).Cut
    .ActiveSheet.Paste
End With

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[aldi07]

SkipVought, thank you for your answer. You are quite right. Problem resolved.