Copy a File to the Clipboard
 

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

Copy a File to the Clipboard
 

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

Copy a File to the Clipboard
 

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?

Copy a File to the Clipboard
 

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

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


- Balmi