I want to copy a directory & all its files to a new directory from within Access 2000

[Wrighttrak]

In VBA behind a Command Button I want to copy a directory to a new directory. Ive tried FileCopy but I dont know how to use *.* in that command

[debasisdas]

no need to use *.*

you need to loop through all the files in the directory and copy them from source to destination.

[vb5prgrmr]

To add to debasisdas post, you will need to know these commands that you can look up in help...

Dir Function
Name Statement or FileCopy Statement along with the Kill Statement (if moving)
MkDir Statement
RmDir Statement (if moving)



Good Luck

[Wrighttrak]

Does any one have a simple vba procedure to make a list of the files in a particular directory so it can be used with FileCopy later

[vb5prgrmr]

Time to use your friends (yahoo, google, ask, answers, bing) to search for vb6 dir function, or you could use the example that should be in the help files for vba (don't know if it is still there or not)...



Good Luck