Copy file from Excel

  • Thread starter Thread starter loopoo
  • Start date Start date
L

loopoo

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Select avaya cms server from shell option VBA 0
Create / Delete folder 3
Help with copying a sheet from One workbook to another workbook 1
Check if a folder exist 5
Copying a Picture From Cell Comment 0
Parse string 2
XCL 2010 VBA: I want to copy/paste from a rtf file to a spreadsheet 7
HELP!!! Excel with C++ 0

Back
Top