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
<(E-Mail Removed)> 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