Copy FIle 1

[Hawkide]

How can I copy a file from one folder to another using VBA? I could probably use a shell command, but there must be another way. TIA...

 

[Dimandja]

FileCopy source, target

 

[GDGarth]

If you're just putting the file into a different folder on the same drive, you can use the Name command:

Name (Filename) as (Newname)

 

[Hawkide]

Thanks guys...

 

[rsinj]

I found it to be easier and more robust not to use FileCopy or Name and just use the SHFileOperation API function as it gives you much more flexibility, and if there is an error, it won't raise it (gives you back the error code) and create handling headaches for you.

Also, though you'd think Name would just do a rename, it actually does a copy followed by a delete. Try it on a large file - it should be instantaneous, but, you can watch in Explorer as it does the copy. The SHFileOperation let's you do a real rename - and again, many more options than what VB provides you with.

http://www.cybersouk.com/article5.html

 

[jadoogar]

I want to copy *.txt to floppy drive
What should I do with Myfilecopy?
Myfilecopy("*.txt","A:")?