how to copy a picture from a cell and paste it in desktop

Question

1.00/5 (3 votes)

See more:

I have a picture in a cell and to copy it and paste it in desktop , I tried the following:

Firstly, I highlighted that particular cell.
Secondly, I selected the 'paste' in the bar and chose 'as picture' and then 'copy as picture' and in the copy picture dialog box I selected 'As shown in screen' and under format I chose 'picture' and pressed 'OK' button and as such I got the picture in the clipboard. Well. But how to copy this picture in clipboard and paste it in desktop?

Posted 11-Apr-14 23:58pm

S.Rajendran from Coimbatore

Add a Solution

Comments

[no name] 12-Apr-14 6:32am

What? If the picture is in the clipboard, ctrl + v should paste the picture anywhere.

S.Rajendran from Coimbatore 12-Apr-14 6:54am

ctrl+v when used is copying in word but in desktop, i have a folder xx and I want it to be pasted there and that is not hapenning.

[no name] 12-Apr-14 9:41am

If ctrl+v pastes a picture from your clipboard in Word, then crtl+v will work for a folder too. If it is not working for you then there is something that you are not telling us.

[no name] 12-Apr-14 10:25am

You might get better help if you posted the code that you wrote that copies the image to the clipboard.

S.Rajendran from Coimbatore 12-Apr-14 10:47am

There is no code, it is all manually done.

[no name] 12-Apr-14 11:26am

What do you mean "there is no code"? You mean to tell me that this whole thing has nothing at all to do with programming and is completely off topic?

gggustafson 12-Apr-14 10:27am

When in Word, try Edit -> Paste Special

S.Rajendran from Coimbatore 12-Apr-14 10:50am

No, it is not allowing to paste

gggustafson 12-Apr-14 11:40am

I just copied the Code Project logo into Work 2003. Took the following steps:
1. Go to the top of the page and right click on the green guy.
2. In context menu click on Copy.
3. Open Word.
4. Edit->Paste Special->Device Independent Bitmap.
The green guy appears.

How are you differing from this sequence?

S.Rajendran from Coimbatore 12-Apr-14 11:50am

Well everything is hapenning but my requirement as said earlier is to paste in a folder of desktop.

gggustafson 12-Apr-14 12:05pm

What exactly are you trying to accomplish? Place an icon on the desktop for an executable?

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Andrius Leonavicius · Answer 1 · 2014-04-12T03:31:00

Solution 1

Hi,

I am doing this easily with the embedded pictures. Steps:
1. Select the image.
2. Simple Copy or Copy as Picture... The picture is in the clipboard now.
3. Open any picture editing software (MS Paint, Photoshop) and paste it there.
Note: In MS Paint you might need to crop the image (after pasting: Right Click on the image -> Crop) in order to resize the canvas to the size of the image.
4. Save the picture in desired format and location.
5. Done.

Posted 12-Apr-14 3:31am

Andrius Leonavicius

Updated 12-Apr-14 4:01am

v3

Comments

S.Rajendran from Coimbatore 12-Apr-14 10:43am

I tried as you said, and the image allowed me to copy in 'paint' and when I wanted to paste in desktop it is not hapenning!!

Andrius Leonavicius 12-Apr-14 11:06am

You haven't done the step 4 correctly. Instead of trying to save the picture directly from the clipboard to the desktop, you need to save the picture from MS Paint using Save or Save as.

S.Rajendran from Coimbatore 12-Apr-14 11:25am

I have saved the picture in 'paint' and when I tried to copy it is not allowing to copy!

Andrius Leonavicius 12-Apr-14 11:37am

Why you are trying to copy the picture from MS Paint??? You need to save it to the desktop from MS Paint using Save or Save as. That's it! You should have it on the desktop.

Andrius Leonavicius 12-Apr-14 11:43am

Or maybe I don't understand what exactly you are trying to do...?

Andrius Leonavicius 12-Apr-14 11:14am

Alternative way to do this is to paste the picture into MS Word, Right Click on the picture -> Save as Picture...
I am not sure if this always works...

S.Rajendran from Coimbatore 12-Apr-14 11:25am

Well..I tried it is not helping

Maciej Los 12-Apr-14 11:45am

@S.Rajendran from Coimbatore,
It's impossible to paste image content (not image file) directly on the desktop!
You need to paste it into proper application, like Paint and then save it as an image.
Are we clear?

Maciej Los · Answer 2 · 2014-04-12T05:51:00

Please, read my comment (to Solution1)!

If you would like to automate the "image copy" process, you can use VBA[^]. All you need to do is to insert new module[^] and then copy one of below functions.

Have a look here:
http://stackoverflow.com/questions/18232987/export-pictures-from-excel-file-into-jpg-using-vba[^]
http://snipplr.com/view/54755/[^]
http://www.mrexcel.com/forum/excel-questions/233108-visual-basic-applications-code-export-image-file-preferably-jpg.html[^]
http://www.vbforums.com/showthread.php?538529-Export-an-Image-from-Excel-Sheet-to-Hard-Drive[^]