+ Reply to Thread
Results 1 to 7 of 7

Create Folder for Selected Cell Value in Excel

  1. #1
    Forum Contributor
    Join Date
    12-18-2019
    Location
    chennai
    MS-Off Ver
    excel 2010
    Posts
    141

    Create Folder for Selected Cell Value in Excel

    Hi Seeking help to create macro

    I want to create multiple folders with selected cells in Excel.

    Folder name is text of whatever cells i am selecting. (Example if i select B5 and B5 having text of "APPLE" then folder created in the name.

    Path of the folder - user has to browse and select.

    Please help

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Create Folder for Selected Cell Value in Excel

    Please Login or Register  to view this content.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  3. #3
    Forum Contributor
    Join Date
    12-18-2019
    Location
    chennai
    MS-Off Ver
    excel 2010
    Posts
    141

    Re: Create Folder for Selected Cell Value in Excel

    Hi AlphaFrog

    Thanks for your help. This is perfectly working as expected.

    Only one issue if i select multiple Cells its creating only for 1st Cell

    Can you fix this

  4. #4
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Create Folder for Selected Cell Value in Excel

    Do you want to browse a root Path for each cell or use the same one for all selected cells?

  5. #5
    Forum Contributor
    Join Date
    12-18-2019
    Location
    chennai
    MS-Off Ver
    excel 2010
    Posts
    141

    Re: Create Folder for Selected Cell Value in Excel

    Hi AlphaFrog

    Path is Same one, for all Selected Cells

    Thanks

  6. #6
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Create Folder for Selected Cell Value in Excel

    Please Login or Register  to view this content.

  7. #7
    Forum Contributor
    Join Date
    12-18-2019
    Location
    chennai
    MS-Off Ver
    excel 2010
    Posts
    141

    Re: Create Folder for Selected Cell Value in Excel

    Thank you so much. its perfectly working as expected.

+ 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. copy checkbox selected listed files from base folder to user selected folder
    By ayush842001 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-16-2020, 08:23 AM
  2. Create Folder & Check if Folder Exists if Not Create Folder & then Save File
    By Quivolt in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-28-2017, 05:31 AM
  3. Create Folder, Sub Folder and Text File from a Cell Value
    By manaswin in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-12-2017, 12:32 PM
  4. [SOLVED] Excel VBA, Macro Shortcut: Create Outlook Calendar Based On the Date of the Selected Cell
    By clprdctn in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-08-2016, 10:23 AM
  5. Replies: 5
    Last Post: 09-13-2012, 09:49 AM
  6. [SOLVED] Create a new folder based on a cell name or value and save copy onto that folder
    By Le_Tiago in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-20-2012, 01:33 PM
  7. Replies: 6
    Last Post: 08-11-2006, 03:41 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