How to copy CHART into ADD-IN ?

[marco02]

Hi,

I'm trying to copy a Charts from a Worbook to an Add-in.
This code below doesn't work,

. IS IT POSSIBLE ?
. HOW SHALL I DO IT ?

> Dim c_Chart as Chart
> For Each c_Chart In Workbooks(MyWorkBook).Charts
c_Chart.Copy After:=wb_Addin.Worksheets
(wb_Addin.Worksheets.Count)
> Next c_Chart

thks a lot,
marco

 

[SkipVought]

marco,

How about...

c_Chart.Copy After:=wb_Addin.Charts(wb_Addin.Charts.Count)

??? Skip,
SkipAndMary1017@mindspring.com

 

[marco02]

Nope skip, doesn't work either

1) I have 1 Worksheet and 9 charts in my Add-in.
2) I display the charts of the add-in to the user and he
can modify them if he wants.
3) If he wants to save his changes, I NEED TO DUMP
THE CHARTS BACK in the Add-in.

i don't know why the method doesn't work. It's propably object management with add-ins ...

any other good ideas lads ?

marco.

 

[SkipVought]

Are thes charts embedded in worksheets or are they workbook.chart objects? Skip,
SkipAndMary1017@mindspring.com

 

[marco02]

Skip, they are Woorkbook.chart objects. I refer to them as usual .Chart(ChartName) etc ...

Since the .Copy doesn't work, I'm out of ideas ...
I didn't find anything working yet :-(

thks for any idea !