R
rukkie
Hi,
I have something "strange " (at least for me) going on ...
I have an xls workbook, containing some data sheets and also 3 chart
templates. These chart templates are copied via a macro to the output
xls with the statement :
Sheets(ChartName) _
.Copy Before:=Workbooks(targetfile.Window).Sheets(1)
When I now look to this chart template in the output xls I got a link
to the original xls workbook in which the macro is running. (I can see
that via EDIT>LINKS...)
Now I do NOT want that link to the originator xls workbook at all !
Is there anybody who knows how I can copy a chart template to another
workbook without the link (reference) to original workbook ?
Any help is very appreciated !!
I have something "strange " (at least for me) going on ...
I have an xls workbook, containing some data sheets and also 3 chart
templates. These chart templates are copied via a macro to the output
xls with the statement :
Sheets(ChartName) _
.Copy Before:=Workbooks(targetfile.Window).Sheets(1)
When I now look to this chart template in the output xls I got a link
to the original xls workbook in which the macro is running. (I can see
that via EDIT>LINKS...)
Now I do NOT want that link to the originator xls workbook at all !
Is there anybody who knows how I can copy a chart template to another
workbook without the link (reference) to original workbook ?
Any help is very appreciated !!