473,473 Members | 2,003 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

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 1201

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: JakeC | last post by:
Hey all, I'm currently redesigning a website that a friend and I started about a year ago. It is a daily surf report so when choosing the best script/language to use for the new design, I found...
1
by: Sarah | last post by:
Hi, Can someone please tell me if there's a way to copy image files from one server to another using ASP and FSO? Or perhaps some other way to do it? I'm trying to collect information on...
102
by: me | last post by:
How do I prevent the save/print/email/mypictures toolbar from popping up when IE users place their cursor over photos at my website? Thank you in advance for your help. Signed, me
0
by: Michael | last post by:
Hi All, I am working on my intranet reporting web site, by use of IIS5 + Office2000 +SQL2000. Currently, the first step, I show user an ASP web-interface to collect user input, keyword...
0
by: Michael | last post by:
Hi All, I created a web page from Excel2000, using "Save as web page..."...Publish function. then, I moved htm file to my IIS web server. Then I added a form control, and submit button. How...
2
by: wisaac | last post by:
What I would like to do is automate the manual process of copying an image from an excel spreadsheet to the clipboard, and pasting it into an access table with an OLE Object field. I want to do...
48
by: mantrid | last post by:
Hello Is there a way to prevent users copying a full size image from a web page. Displaying the image with a smaller width and height only affects the image as viewed, the actual full size image...
6
by: Mark C | last post by:
how do you prevent users from copying ctrl-c content from your textboxes. I know how to do this with IE which is <body onSelectStart="return false;"> but does not work in Mozilla Thanks Mark...
4
by: Zeljko Bilandzija | last post by:
Hy, could someone help me in this: In design mode, i want to put pictures in database. I made column named pics, and its type as image. How can I put pictures or some address of these pictures...
1
by: =?Utf-8?B?c3BhaW5jYw==?= | last post by:
I have always been able to create folders with pictures from my digital camera. Then by selecting all pictures and then selecting copy to cd, I could copy my pictures to a CDRW. Now I am...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
1
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
1
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
0
muto222
php
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.