+ Reply to Thread
Results 1 to 6 of 6

Macro to help organize the directories by date

  1. #1
    Registered User
    Join Date
    09-27-2016
    Location
    Brazil
    MS-Off Ver
    2010
    Posts
    4

    Macro to help organize the directories by date

    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!

  2. #2
    Forum Expert
    Join Date
    02-14-2009
    Location
    .
    MS-Off Ver
    ................
    Posts
    2,840

    Re: Macro to help organize the directories by date

    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.

  3. #3
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Macro to help organize the directories by date

    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!)

  4. #4
    Registered User
    Join Date
    09-27-2016
    Location
    Brazil
    MS-Off Ver
    2010
    Posts
    4

    Re: Macro to help organize the directories by date

    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!

  5. #5
    Registered User
    Join Date
    09-27-2016
    Location
    Brazil
    MS-Off Ver
    2010
    Posts
    4

    Re: Macro to help organize the directories by date

    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!

  6. #6
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Macro to help organize the directories by date

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Macro to save workbook - Create Directories / Sub-Directories Based using text in cells
    By kspeese in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-06-2014, 01:21 PM
  2. VBA Macro to Loop and Merge Files in Several Directories
    By sanjeevpandey in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-18-2013, 10:53 AM
  3. Macro to delete contents of 2 directories not deleting the second
    By RebeccaEllis in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-09-2012, 04:57 PM
  4. Re-organize date and units into different formats
    By will40 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-29-2012, 01:30 AM
  5. How to create multiple directories from cells using a macro or VBA
    By riskmgr in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-22-2011, 10:16 AM
  6. Organize data into sheets by Date
    By cyanidepwns in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-17-2010, 05:19 PM
  7. Organize data based on criteria and date
    By dcaba in forum Excel General
    Replies: 1
    Last Post: 02-13-2010, 06:12 AM
  8. [SOLVED] How do I organize entries in order by date each rqst was rcvd?
    By floridapio in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 10-05-2005, 02:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1