Hi Rod,

What if you copy the chart to a new workbook and then break the links?
(Edit- Links- Break Link)It is still a chart, but the data is then saved in
the chart and not linked to source data.

Good luck,
----- Original Message ----- 
From: "Rod N Dickson" <[log in to unmask]>
To: <[log in to unmask]>
Sent: Friday, February 25, 2005 12:26 PM
Subject: Re: Copying Charts into Different Workbooks

Further to this query,

The "ChartObject" has a "CopyPicture" method which can be used in place
of the "Copy" method when grabbing the chart or, for that matter, any
range object within the workbook. I have looked it up on Excel 2003 on
a PC and the same methods are available.

(My version was incorrect for Mac - I use Office 2004 on the Mac,
Office 2003 and below on a PC)


On Feb 25, 2005, at 10:56 am, Rod N Dickson wrote:

I use a Mac with Office 2004 which may make a slight difference,
however when I have a chart on a worksheet I can select the chart and
then save the chart as a picture to the desktop, or where ever. This
would bypass the word step you mention.


On Feb 25, 2005, at 10:10 am, Fen Scott wrote:

Hi guys.

I wonder if anyone can help me with this:-

I want to copy a number of charts from one workbook into a new
workbook, but not have a link to the original workbook, so in essence
want the new charts to be pictures. I can do this manually using Word
as an interim step, by pasting the chart into word as a picture and
then pasting into the new workbook as a picture.

I am going to be doing this automatically using Excel VBA, so can
anyone advise how to do this:

1) Without the interim Word step

2) Using the interim step, in Word. My knowledge of automating
Word, using Excel VBA is somewhat “limited”!

Many thanks in advance for your help.

Best wishes,

Fen Scott.