+ Reply to Thread
Results 1 to 5 of 5

Make folders from List

  1. #1
    Forum Contributor
    Join Date
    04-18-2006
    Posts
    135

    Make folders from List

    Hi I have a list of directories in column A and I would like to create a macro to go through all the calls in column A then create the appropriate folder based on information contained in the cell.
    so far I have this (see below but I dont know how to make the macro loop through the list. Can some one give me a hand please?

    Please Login or Register  to view this content.

  2. #2
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,885
    Vlad, try this code:
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    04-18-2006
    Posts
    135
    Thank you for the VERY quick reply

  4. #4
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,885
    You're welcome. Glad I could help.

  5. #5
    Forum Contributor
    Join Date
    04-18-2006
    Posts
    135
    Sorry just one problem it is crashing because the some folders already exist.

    Is there anyway to make it so that it ignores this error then just creates the sub folder in the appropriate directory?

+ 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