Copy chart to clipboard

[Libby]

Hi I've been using

Dim x as DataObject
x.SetText "Mytext"
x.PutInClipboard

to place various thing in the clipboard to allow them to be easily pasted
elsewhere.

Does anyone know how to apply this to charts?

I have a worksheet containing two charts, both of which I would like to be
copied to the clipboard when a button is clicked so that they can be pasted
as a single metafile into another document.

Many thanks in advance.

Libby

 

[Peter T]

Hi Libby,

The DataObject only accepts text.

Record a macro, with the chart selected, on the main menu hold Shift and
select Edit, Copy Picture.
Experiment with the top two options but to copy as a metafile ensure the
Format option is Picture.

Tidy up the recorded macro.

Not sure what you mean by copy two charts then paste as a single metafile.
You will need to copy paste one at a time, maybe to can combine the two
images as one in the other application.

Regards,
Peter T