469,934 Members | 1,540 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,934 developers. It's quick & easy.

Copying pictures in Excel2000

Hi, i am using C# to automate excel. i am trying to create a sheet of
thumbnail images which i create in one worksheet and copy to another
sheet. in vb.NET the code looks like this:

' copy the chart as a picture
..ActiveChart.CopyPicture(Appearance:=Excel.XlPict ureAppearance.xlScreen,
Size:=Excel.XlPictureAppearance.xlScreen,
Format:=Excel.XlCopyPictureFormat.xlBitmap)
..ActiveWorkbook.Sheets("Graphs_100%Vol").Select()
..ActiveSheet.Cells(InsertYOffset, InsertXOffset).Select()
..ActiveSheet.Paste() 'Special Format:="Picture (Enhanced Metafile)",
Link:=False, DisplayAsIcon:=False

in C# i can create the chart and save it as a bitmap to the clipboard
but can't work out how to paste it into the correct place in the other
sheet. here is what i have so far:

chart.CopyPicture(Excel.XlPictureAppearance.xlScre en,
Excel.XlCopyPictureFormat.xlBitmap,
Excel.XlPictureAppearance.xlScreen);
thanks for you help.

Matt

Nov 17 '05 #1
0 1102

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by JakeC | last post: by
48 posts views Thread by mantrid | last post: by
4 posts views Thread by Zeljko Bilandzija | last post: by
1 post views Thread by =?Utf-8?B?c3BhaW5jYw==?= | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.