Challenge ! Pasting objects from Clipboard

[FaneDuru]

How is it possible to copy and paste an embedded object from an Excel worksheet (a picture).

With the code: "Sheets(1).Shapes("Pict&quot.Copy" the embedded object is loaded in the Clipboard Memory.
If I wont to Paste it manually I can.

There has to be some API able to do that. It is not so easy......

I have a solution for transporting a picture in an Excel file but I'd like to know how it's possible. I load the picture (any object) in binary mode on the Excel file (passing it through an array) and restore it with:
"Open x For Binary As #1
For i....
Put #1, i, Matr(i)
Next i
Close #1"

Thanks,
Fane Duru'

 

[Stretchwickster]

Can you not use ActiveSheet.Paste?
Check it out in the help.

Clive

http://www.kucu.co.uk

Ex nihilo, nihil fit (Out of nothing, nothing comes)

 

[FaneDuru]

Sorry, I was not very clear.....
I wont to Paste the object somewere in a FOLDER !
I wont to rebuild it......

Anyhow, I did not understand what you mean with "Can you NOT use Activesheet.Paste?"

Fane Duru'