Results 1 to 10 of 10

Create Dated Folder with Subfolder from Cell Values

Threaded View

bloomingcarrot Create Dated Folder with... 10-16-2014, 04:45 PM
JBeaucaire Re: Create Dated Folder with... 10-16-2014, 10:13 PM
bloomingcarrot Re: Create Dated Folder with... 10-16-2014, 10:24 PM
JBeaucaire Re: Create Dated Folder with... 10-16-2014, 10:47 PM
bloomingcarrot Re: Create Dated Folder with... 10-17-2014, 07:46 PM
JBeaucaire Re: Create Dated Folder with... 10-17-2014, 09:54 PM
bloomingcarrot Re: Create Dated Folder with... 10-21-2014, 03:53 PM
JBeaucaire Re: Create Dated Folder with... 10-21-2014, 05:01 PM
bloomingcarrot Re: Create Dated Folder with... 10-21-2014, 05:24 PM
JBeaucaire Re: Create Dated Folder with... 10-21-2014, 05:53 PM
  1. #1
    Registered User
    Join Date
    09-22-2014
    Location
    Los Angeles, CA
    MS-Off Ver
    2011
    Posts
    39

    Create Dated Folder with Subfolder from Cell Values

    Hi All-

    I'm fairly new to VBA code so forgive me if this is extremely simple and/or poorly worded... To note: I am on Excel 2011 for MAC. What i would like to do is create one button and assign one macro to it. I would like the macro to create a dated folder with today's date (mmddyy) and then save subfolders with the folder names determined from cells A1_B1, A2_B2, A3_B3, etc.

    So essentially the final directories would look like this:

    Macintosh HD:Users:clairephillippi:SPREADSHEET:VERSIONS:TEST:mmddyy:
    Macintosh HD:Users:clairephillippi:SPREADSHEET:VERSIONS:TEST:mmddyy:A1_B1
    Macintosh HD:Users:clairephillippi:SPREADSHEET:VERSIONS:TEST:mmddyy:A2_B2
    Macintosh HD:Users:clairephillippi:SPREADSHEET:VERSIONS:TEST:mmddyy:A3_B3

    This is the code that I am currently using. It creates folders with the date and folder name like this: 101614A1_B1

    Sub MakeFolders()
     
    Dim FldrName As String
     
    On Error Resume Next
     
    dirName = "GFXM1:STUDIO:TOTAL_ACCESS:TA_14:TA_Versioning 2014:24.00_Intro_Wall:_SPREADSHEET:VERSIONS:TEST:" & " " & Format$(Date, "mmddyy"):
     
    For i = 7 To 10
       FldrName = Cells(i, 1).Value & "_" & Cells(i, 2).Value
       MkDir dirName & FldrName
    Next i
      
    End Sub
    Any and all help would be greatly appreciated!!!
    Last edited by JBeaucaire; 10-16-2014 at 10:08 PM. Reason: Added missing CODE tags. Please read and follow the Forum Rules, link above in the menu bar. Thanks.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Code to create folder and inside subfolder
    By kosherboy in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 03-07-2014, 03:03 PM
  2. Create FOLDER / SUBFOLDER from CULUM
    By mash1 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-13-2012, 09:29 AM
  3. Macro to Create Folder\Sub Folder\SubFolder\
    By coolhit in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-30-2012, 12:43 PM
  4. [SOLVED] Macro to create subfolder in Oultook & directory folder
    By twitch73 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-26-2012, 09:41 PM
  5. Create folder and subfolder in four layers
    By monsterdvd in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-12-2011, 05:47 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