+ Reply to Thread
Results 1 to 4 of 4

Macro for creating folder in teh name of date(15/12/2012)

  1. #1
    Forum Contributor
    Join Date
    01-25-2013
    Location
    Chennai
    MS-Off Ver
    Excel 2003
    Posts
    112

    Macro for creating folder in teh name of date(15/12/2012)

    Hi Guys,

    I'm looking for macro needs to create a folder in teh format of date ? if teh folder is not alreadyy exist?
    Can some one help me ?

  2. #2
    Valued Forum Contributor
    Join Date
    08-13-2012
    Location
    Gardony, Hungary
    MS-Off Ver
    Excel 2003
    Posts
    558

    Re: Macro for creating folder in teh name of date(15/12/2012)

    Hi,

    as far as I know, you can't have special characters, such as "/" in folder names.

  3. #3
    Forum Expert OllieB's Avatar
    Join Date
    12-20-2012
    Location
    Netherlands
    MS-Off Ver
    Excel 2007 (home) & 2010 (office)
    Posts
    1,542

    Re: Macro for creating folder in teh name of date(15/12/2012)

    I am sorry but the name of a folder may not contain the characters "/" or "\".

    The "-" character is allowed though

    You can use the following example code to create the folder if it doesn't already exist

    Please Login or Register  to view this content.
    If you like my contribution click the star icon!

  4. #4
    Forum Contributor
    Join Date
    01-25-2013
    Location
    Chennai
    MS-Off Ver
    Excel 2003
    Posts
    112

    Re: Macro for creating folder in teh name of date(15/12/2012)

    Hi OllieB,

    Tahnsk for your code

    Taht gave me a clear picture...

    The belwo is my working code.. i ahve created the code and its Okay i guess.

    But thing is that its only one time creating the folder first time and saving teh file..

    While code running for teh next row, its doesnt creating teh other folder(sname folder).

    Can you advise what is the issue is ?

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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