Vba code to create folder ans archive WBk files
Posted on 2013-01-23
I need a macro that will archive all the workbooks in the following path:- Dir("C:\Documents and Settings\Test\*.xls")
To a folder name the user specify and creates via pop up window...
Once the files have been archived and If the user acciendtially tries to copy across the source files and the folder is empty then magbox you have no files on current folder...
If updated file are saved in the above file path and the user which to save these to the created folder and they are of the same name then over write previous version and move..