+ Reply to Thread
Results 1 to 4 of 4

Creating sub directory.

  1. #1
    Forum Contributor
    Join Date
    02-26-2009
    Location
    Auckland, New Zealand
    MS-Off Ver
    Excel 2010
    Posts
    286

    Creating sub directory.

    I am using the following code to create a directory if it does not exist. If cell C4 has “12400” then a directory “12400-12499” is created i.e. "S:\MTL_DATA\Quotes\12400-12499".
    I wish to know how to modify this code so that another sub directory is created, in this case “12400” i.e. "S:\MTL_DATA\Quotes\12400-12499\12400". If cell C4 has 12401 then "S:\MTL_DATA\Quotes\12400-12499" remains but a new sub directory is “12401” i.e. "S:\MTL_DATA\Quotes\12400-12499\12401".
    Thanks Sandy

    Please Login or Register  to view this content.

  2. #2
    Forum Guru karedog's Avatar
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,971

    Re: Creating sub directory.

    Maybe :
    Please Login or Register  to view this content.
    1. I care dog
    2. I am a loop maniac
    3. Forum rules link : Click here
    3.33. Don't forget to mark the thread as solved, this is important

  3. #3
    Forum Contributor
    Join Date
    02-26-2009
    Location
    Auckland, New Zealand
    MS-Off Ver
    Excel 2010
    Posts
    286

    Re: Creating sub directory.

    Thanks Karedog that worked just how I wanted it to. Cheers Sandy

  4. #4
    Forum Guru karedog's Avatar
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,971

    Re: Creating sub directory.

    You are welcome, Sandy.
    Thanks for marking the thread as solved.

    Regards

+ 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] Creating an image directory using a macro
    By jleal in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 08-25-2015, 01:50 AM
  2. [SOLVED] Help with some code for creating new sheets from a directory
    By exarranum in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-26-2013, 02:39 AM
  3. Save As and Creating Directory
    By Joelyfish in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-21-2008, 06:45 AM
  4. Creating Find Tool for Directory
    By isaacjohny in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 10-28-2008, 07:05 AM
  5. Creating a directory
    By justchris in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-01-2006, 10:19 PM
  6. Creating a directory
    By Graham Whitehead in forum Excel General
    Replies: 1
    Last Post: 06-22-2006, 08:50 AM
  7. Creating Links to files in a shared directory
    By grewpp in forum Excel General
    Replies: 4
    Last Post: 02-09-2006, 12:25 PM

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