By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,537 Members | 1,743 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,537 IT Pros & Developers. It's quick & easy.

Copying pictures in Excel2000

P: n/a
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
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.