Copy file from Excel
 

Hi!

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

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

Thanks in advance,
Chri

--
loopo
-----------------------------------------------------------------------
loopoo's Profile: http://www.excelforum.com/member.php...fo&userid=2879
View this thread: http://www.excelforum.com/showthread.php?threadid=49222

Copy file from Excel
 

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

Copy file from Excel
 

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

Copy file from Excel
 

Thank you for your help,
Chris


--
loopoo
------------------------------------------------------------------------
loopoo's Profile: http://www.excelforum.com/member.php...o&userid=28792
View this thread: http://www.excelforum.com/showthread...hreadid=492221