Copy a File to the Clipboard

[ansgar]

Hello,

i like to copy a file programmatically to the clipboard.
I mean the programmatically procedure to copy a file (not the content)
as the same command inside MS-Explorer -> right-click -> copy.

Thanks all.

Balmi

 

[Gord Dibben]

See VBA help on "filecopy"

What do you want to do with the copied file BTW?


Gord Dibben MS Excel MVP

 

[ansgar]

Hello Gord,

thanks for your answer, but filecopy only copies the file to another
location.

What I want to do:
My Makro saves a Chart as a Image-file to a temporary folder and now i
need to copy the created file into the clipboard.
The reason is, that the user now can insert directly the image over
CTRL+V into Word, Powerpoint, ... or into a another folderlocation as
a file.

Balmi

 

[ansgar]

The solution: http://www.vb-hellfire.de/download/other/setclipboardfiles.zip

many thanks to: Thorsten Dörfler (Microsoft MVP Visual Basic)


- Balmi