+ Reply to Thread
Results 1 to 6 of 6

Creating A New Folder With Current Date

  1. #1
    Registered User
    Join Date
    12-26-2007
    Posts
    24

    Creating A New Folder With Current Date

    Hi,

    Can anybody let me know how to create a new folder with current date ? and also how to move all the .csv files i have in one folder to another. Thank you.

    Regards,
    Jeffrey

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    This will create a new folder

    Please Login or Register  to view this content.
    You could create a loop to move the files. If no-one does it for you I will have a look at it after work
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Registered User
    Join Date
    12-26-2007
    Posts
    24
    Thanks for the help. Have tried the code, however there is an error saying that the path not found. Have been fooling around with the code for few hours and did not get it working.

  4. #4
    Valued Forum Contributor mudraker's Avatar
    Join Date
    11-10-2003
    Location
    Melbourne, Australia
    Posts
    3,983
    Please read forum rules

    This is a small extract of Rule 3
    Rule 3). Ensure Your question is not too vague
    More detail of where you needed to create the folder would have resulted in a more detailed answer that was more suited to your needs

    Roy's code gives 2 ways of creating the folder
    Remove whichever line of code does not suit your needs

    creates a new folder in the active folder
    Please Login or Register  to view this content.
    Create a new folder in a different location
    change C:\My Documents\ to suit
    Please Login or Register  to view this content.
    Another option
    Create folder in Excels default folder
    Please Login or Register  to view this content.

    For moving files
    try this macro
    Change paths as required
    Please Login or Register  to view this content.
    Please Read Forum Rules Before Posting
    Wrap VBA code by selecting the code and clicking the # icon or Read This
    How To Cross Post politely

    Top Excel links for beginners to Experts

    If you are pleased with a member's answer then use the Scales icon to rate it
    If my reply has assisted or failed to assist you I welcome your Feedback.

  5. #5
    Registered User
    Join Date
    12-26-2007
    Posts
    24
    Hi,

    Thanks for your help. I have tried that before ( commenting one of the line out) but to no avail i am afraid.

    Regards
    Jeffrey

  6. #6
    Registered User
    Join Date
    12-26-2007
    Posts
    24
    FOUND THE ERROR. Was me foolishly entered the wrong directory !! Can you also let me know how to save file to my newly created folder ? save to folder by date ? is that possible ? thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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