Hi!
I would like to organize my directories by date.
For example, all the documents created in 2015, I would like to creat a file and put all of them on it. But i have no idea how to start it.
Thanks!
Hi!
I would like to organize my directories by date.
For example, all the documents created in 2015, I would like to creat a file and put all of them on it. But i have no idea how to start it.
Thanks!
Is there a particular reason why you want to do this by writing a VBA program? It would be faster and much more efficient to simply use Windows Explorer to create directories and move files yourself.
Hello GiuliaPP,
Welcome to the Forum!
You say you want to create a file for all documents created in 2015. Did you mean a new folder instead of a file?
You need to more specific about the document type. Are you referring to Excel documents only?
Do you want to look at all documents in a single folder or all folders in a parent folder?
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Star below the post.3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Yes! sorry, i meant a new folder.
Actually, i would like to move every kind of documents (excel, word, etc) and the document are all in the same folder, not in a parent one.
Thank you!
Yes! sorry, i meant a new folder.
Actually, i would like to move every kind of documents (excel, word, etc) and the document are all in the same folder, not in a parent one.
Thank you!
Hello GuiliaPP,
Add a new VBA Module to your workbook and paste the macro below into it. Currently, the new folder will be located on the Desktop. Please change the location to what you want before running the macro.
Please Login or Register to view this content.
Last edited by Leith Ross; 11-11-2016 at 03:37 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks