ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Paste Graphs as Pics with 2003 in a VBE (https://www.excelbanter.com/excel-discussion-misc-queries/236049-paste-graphs-pics-2003-vbe.html)

Aligi

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


All times are GMT +1. The time now is 11:38 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com