G
Guest
I am looking to create a Module in Access that will create a directory based
on the current month/ year and then move all files from one direct to it.
ie create directory "C:\reporting\2006 Jan"
copy "C:\reporting\data\*.*" "C:\reporting\2006 Jan"
delete "C:\reporting\data\*.*"
Do you know the syntax please?
Also want it so it doesn't prompt for confirmation?
on the current month/ year and then move all files from one direct to it.
ie create directory "C:\reporting\2006 Jan"
copy "C:\reporting\data\*.*" "C:\reporting\2006 Jan"
delete "C:\reporting\data\*.*"
Do you know the syntax please?
Also want it so it doesn't prompt for confirmation?