move all specific files from entire disk

[bojzon]

Need help with subroutine:

searching on entire C:\ for:
- all specific files (p.e. starting with characters BACK - "BACK123.XLK"
- with extension XLK(or XLS, or DOC),
except searching (skip) folder C:\Backups

- and MOVE all (with overwrite) to destination C:\Backups\M
- and COPY all (with overwrite) to destination C:\Backups\C

thanks

Bojzon

 

[PHV]

What have you so far ?
Take a look at the FileSystemObject instantiated like this:
Set fso = CreateObject("Scripting.FileSystemObject")
On line documentation here

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[bojzon]

Entire C disk with all subdirectories levels ???

 

[PHV]

Yes it's possible taking in account that VBA functions are recursive.

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884