Paste Graphs as Pics with 2003 in a VBE

A

Aligi

Hi there,

I wrote this macro below which is working with 2007 to copy paste some
graphs as pictures and being used later on as images for ppt. It works fine
with 2007 but the paste special doesn't work with 2003. Is there anything
similar that I can use for 2003 as correct syntax?

Sheets("Graphs").Select
ActiveSheet.ChartObjects("Chart 83").Activate
Selection.Copy
Sheets("Graphs Export").Select
Range("C3").Select
ActiveSheet.PasteSpecial Format:="Picture (JPEG)"

Thank you and regards
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to Copy/Paste Multiple images 3
copying all charts as enhanced metafiles 7
Adding a hyperlink to a picture in Excel 2007 3
Can't get Linked Excel Graphs to Update in Word 1
compress pictures 5
Can I preserve PP2007 animated graphs in PP2003? 2
Pasting Excel-diagrams in Powerpoint maintaining link to Excel dat 5
Can I paste a chart from Excel into a powerpoint slide "Placeholde 1

Top