Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy and Paste Charts as Picture in Different Workbook
Here is my code... everything working except copying and pasting the charts
as picture... no error, the picture of the excel chart just doesn't show up. thanks for any help. SteveC Sub test copy excel charts 'code here, then: Workbooks("Hot List.xls").Sheets("Snapshot").Cells.Copy With ThisWorkbook.Sheets(ShName).Range("A1") .PasteSpecial _ Paste:=xlPasteValues, _ Operation:=xlNone, _ SkipBlanks:=False, _ Transpose:=False Workbooks("Hot List.xls").Sheets("Snapshot").Cells.Copy .PasteSpecial _ Paste:=xlPasteFormats, _ Operation:=xlNone, _ SkipBlanks:=False, _ Transpose:=False Workbooks("Hot List.xls").Sheets("Snapshot").Cells.Copy .PasteSpecial _ Paste:=xlPasteColumnWidths, _ Operation:=xlNone, _ SkipBlanks:=False, _ Transpose:=False Workbooks("Hot List.xls").Sheets("SnapShot").Shapes.Range(Array(" CIQChart1s0t0", "CIQChart1s1t0")).Select Selection.CopyPicture Appearance:=xlScreen, Format:=xlPicture With ThisWorkbook.Sheets(ShName).Range("c48") .PasteSpecial Format:="Picture (Enhanced Metafile)", Link:=False _ , DisplayAsIcon:=False End With Application.CutCopyMode = False 'more code End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy range and paste as picture | Excel Discussion (Misc queries) | |||
Copy and Paste Chart as Picture into another workbook or worksheet | Charts and Charting in Excel | |||
Copy and paste a graph as a picture? | Excel Programming | |||
Copy and paste a graph as a picture? | Excel Programming | |||
copy charts & paste as picture, hide chart, size & place same picture as chart | Excel Programming |