save a picture on desktop

[rounakmoondra]

How do we save a picture present in excel to a folder on our desktop

 

[Jaafar Tribak]

How do we save a picture present in excel to a folder on our desktop

Where in the worksheet do you have the picture ?

If ,for example, the picture is in an image control then you could use something along these lines :

SavePicture Image1.Picture, Environ("USERPROFILE") & "\DeskTop\[I][B]YourFolder[/B][/I]\Image1.jpg"

change the Folder name as required.

 

[rounakmoondra]

I have used the below code...

ActiveChart.ChartArea.Select
ActiveChart.ChartArea.Copy
Sheets("Data").Select
Range("P3").Select
ActiveSheet.Pictures.Paste.Select
SavePicture Image1.Picture, Environ("USERPROFILE") & "\DeskTop\Image1.png"

it gives an error message....

Run time error '424'

object required

Any suggestions.....

 

[doofusboy]

You could try:

SavePicture Image1.Picture,"C:\Documents and Settings\" & Application.UserName & "\Desktop\Image1.jpg"

 

[rounakmoondra]

No luck....same error....

does it gives the name of the picture as Image1 or Picture1...

 

[doofusboy]

Depends on whether the picture is on an Image1 component or a Picture1 component. Which do you have in your workbook?

 

[rounakmoondra]

well its picture tool....and it names the images as
Picture1 Picture2 so on.....
but i tried this as well.....gives the same results.....

 

[rounakmoondra]

is there a way to take the content from the clip board and store it in the folder on your desktop....

as I copy the chart using macro it has a copy on the clipboard as well....so we can take it directly from there and save it in the folder on the desktop.....

 

[Jaafar Tribak]

If you just want to save a picture of a chart to disk then you can use the Chart Export Method as follows :

This will save the chart as a Gif picture file on the C root : ( Change the destination folder as required )

Worksheets(1).ChartObjects(1).Chart.Export _
Filename:="C:\ChartImage.gif", FilterName:="gif"

 

[rounakmoondra]

I have tried this ....export method but the resolution is not good but by taking a picture of graph give more clarity.....
hence i have saved chart on sheet as a picture and now either from
the sheet or from clipboard i want to save it in a folder on my laptop....

thanks for your inputs.......