+ Reply to Thread
Results 1 to 3 of 3

Creating Sub-Folders & Setting Permission

  1. #1
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Creating Sub-Folders & Setting Permission

    Hi,

    I have an excel sheet with a list of folder paths, for example "C:\Users\Deep\Desktop\Named Folders\Games\CS\New".

    I want these sub folders to be created. Currently only "C:\Users\Deep\Desktop\Named Folders" this exists, but I want sub-folders Games, CS & New to be created.

    What is the best way to create the whole directory at once?

    The Problem with using MkDir, is that it needs the whole path to be there for the last folder to be created.
    Last edited by NeedForExcel; 11-04-2015 at 01:41 AM.
    Cheers!
    Deep Dave

  2. #2
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Creating Sub-Folders & Setting Permission

    shrugs
    maybe like this
    http://www.devhut.net/2011/09/15/vba...e-directories/

    Last code on page
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: Creating Sub-Folders & Setting Permission

    Perfect!

    Thanx a lot..

+ 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. Creating folders folders need to set permissions
    By overlord6920 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-14-2014, 07:08 PM
  2. creating sub folders
    By w8itn4you in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-06-2012, 07:01 PM
  3. [SOLVED] Creating Folders and Sub Folders
    By qoios in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-30-2012, 12:57 PM
  4. probems creating folders: "......... folders already existed"
    By AnthonyWB in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-12-2010, 03:04 PM
  5. Creating Folders.
    By AnthonyWB in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-08-2010, 01:23 PM
  6. Help with Creating folders on Save
    By Alarmbloke in forum Excel General
    Replies: 3
    Last Post: 12-22-2005, 02:10 PM
  7. [SOLVED] Creating folders using VBA
    By Fred Smith in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-08-2005, 11:06 AM

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