LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,600
Default Copy and Paste Charts as Picture in Different Workbook

Test my earlier example with a few charts on a sheet, amend the sheet
references to suit. Notice the bit about changing newly pasted pictures
positions to same Left & Top properties of the copied chartobject.

Regards,
Peter T

"SteveC" wrote in message
...
Based on already what I have coded, this will probably work best for me:

Workbooks("Hot

List.xls").Sheets("Snapshot").Range("c48:i64").Cop yPicture _
Appearance:=xlScreen, Format:=xlPicture

With ThisWorkbook.Sheets(ShName).Range("c48").Select
ActiveSheet.PasteSpecial Format:="Picture (Enhanced Metafile)", _
Link:=False, DisplayAsIcon:=False

End With

The trick is getting this picture into the the new worksheet and in the
right place (c48) of the new worksheet. Instead I'm finding the picture
being pasted in the top left corner of the source page (Hot List.xls /
Snapshot). Not the new workbook / worksheet as defined by
"ThisWorkbook.Sheets(ShName).

Dim I As Integer
Dim ShName As String
Dim Sht As Worksheet
Dim buttoms As Shape

and this piece of code doesn't help, deleting all shapes including

pictures:

For Each buttoms In ThisWorkbook.ActiveSheet.Shapes
buttoms.Delete
Next

A big headache. thanks for everyone for taking a look; don't really

expect
a response to this, but had to try.

SteveC







 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy range and paste as picture jlclyde Excel Discussion (Misc queries) 2 April 28th 08 09:52 PM
Copy and Paste Chart as Picture into another workbook or worksheet SteveC Charts and Charting in Excel 1 February 15th 07 11:47 PM
Copy and paste a graph as a picture? funkymonkUK[_104_] Excel Programming 2 March 17th 06 02:45 PM
Copy and paste a graph as a picture? funkymonkUK[_103_] Excel Programming 1 March 17th 06 02:35 PM
copy charts & paste as picture, hide chart, size & place same picture as chart Gunnar Johansson Excel Programming 0 October 30th 04 01:22 AM


All times are GMT +1. The time now is 07:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"