Copy file from Excel

[loopoo]

Hi!

Is there a funcion in VBA that allows me to copy a file from one location to another ??

Like: copy C:\file D:\Temp\file

Thanks in advance,
Chris

[Jim Thomlinson]

FileCopy "Source", "Destination"
--
HTH...

Jim Thomlinson


"loopoo" wrote:

>
> Hi!
>
> Is there a funcion in VBA that allows me to copy a file from one
> location to another ??
>
> Like: copy C:\file D:\Temp\file
>
> Thanks in advance,
> Chris
>
>
> --
> loopoo
> ------------------------------------------------------------------------
> loopoo's Profile: http://www.excelforum.com/member.php...o&userid=28792
> View this thread: http://www.excelforum.com/showthread...hreadid=492221
>
>

[Philip]

Hi,

Yes, you can use the native VBA function "FileCopy" like this

vba.FileCopy "C:\file", "D:\Temp\file"

(or you can use the FileSystemObject)

HTH

Philip

"loopoo" wrote:

>
> Hi!
>
> Is there a funcion in VBA that allows me to copy a file from one
> location to another ??
>
> Like: copy C:\file D:\Temp\file
>
> Thanks in advance,
> Chris
>
>
> --
> loopoo
> ------------------------------------------------------------------------
> loopoo's Profile: http://www.excelforum.com/member.php...o&userid=28792
> View this thread: http://www.excelforum.com/showthread...hreadid=492221
>
>

[loopoo]

Thank you for your help,
Chris