+ Reply to Thread
Results 1 to 2 of 2

Macro to create folders based on content of a cell

  1. #1
    Registered User
    Join Date
    11-09-2012
    Location
    Leeds, England
    MS-Off Ver
    Excel 2010
    Posts
    3

    Macro to create folders based on content of a cell

    Hi All,

    I have to create 500+ folders that will be named the exact contents of a cell, an 8 digit account number and then a name.

    I searched high and low for something but cannot find anything suitable.

    It is basically a list in 1 column (A3-A553, at the minute). As a bonus if it could then display the hyperlink in the next column to the right that would be fantastic. I figure if it is a standalone tool it would be extremely versatile in other applications too.

    If it were 20 folders I wouldn't be so bothered but 500 will mean at least 1 whole day of utter frustration.

    (Future proofing it if it could ignore any already produced would be the icing on the cake.)

    Any help would be greatly accepted.

    Thanking you kindly

    Michael, Leeds, UK

  2. #2
    Forum Expert
    Join Date
    04-22-2013
    Location
    .
    MS-Off Ver
    .
    Posts
    4,418

    Re: Macro to create folders based on content of a cell

    should be simple enough, depends a bit on what the data in your column looks like but to create a folder:
    Please Login or Register  to view this content.
    to loop through the range A and depending where you want them saving:
    Please Login or Register  to view this content.
    to add hyperlinks:
    Please Login or Register  to view this content.
    It won't let you create a folder that already exists so future proofing you can just tell it to ignore errors I think:
    Please Login or Register  to view this content.
    Last edited by ragulduy; 05-24-2013 at 10:51 AM.

+ 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