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

See VBA help on "filecopy"

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


Gord Dibben MS Excel MVP

On Wed, 26 Aug 2009 12:56:37 -0700 (PDT), ansgar
wrote:

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

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


On Aug 26, 11:22*pm, Gord Dibben <gorddibbATshawDOTca
wrote:
See VBA help on "filecopy"

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

The solution: http://www.vb-hellfire.de/download/o...boardfiles.zip

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


- Balmi