View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Aligi Aligi is offline
external usenet poster
 
Posts: 7
Default Paste Graphs as Pics with 2003 in a VBE

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
--
Aligi