+ Reply to Thread
Results 1 to 6 of 6

Dropdown list of folder names/dropdown list of subfolders of selected folder/excel files

  1. 12-11-2019, 03:41 AM #1
    adokskel
    adokskel is offline
    Registered User
    Join Date
    08-05-2010
    Location
    Ankara, Turkey
    MS-Off Ver
    Microsoft 365 MSO (Version 2209)
    Posts
    16

    Dropdown list of folder names/dropdown list of subfolders of selected folder/excel files

    Hello Everybody,

    I wish you ease at your work.
    I am not an excel pro. Just wanted to know if this is easy for you to help.
    If not just forget it. I dont want to waste your time.

    - I wish a dropdown list at first cell of first coloumn which will be listed the name of folders which are located in a folder named "Main" at desktop. Then I will select a folder.
    - Another dropdown list at first cell of second coloumn which will be listed the subfolder names which are loceted in the folder that I selectat previous step.
    - Another dropdown list at first cell of third coloumn which will be listed the names of excel files which are loceted in the subfolder that I select at previous step. Then I select an excel files and want it to open.

    Waiting for your valuable responds.

    Best regards.

    This thread is also asked the forums below:

    http://ozgrid.com/forum/index.php?th...ed-folder-exc/
    http://mrexcel.com/board/threads/dro...files.1117592/
    http://excelguru.ca/forums/showthrea...2665#post42665
    Last edited by Pepe Le Mokko; 12-11-2019 at 04:58 AM. Reason: Added url tags - OP not yet authorized for links
    Reply With QuoteRegister To Reply
  2. 12-11-2019, 04:11 AM #2
    shukla.ankur281190
    shukla.ankur281190 is offline
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Office 365
    Posts
    3,937

    Re: Dropdown list of folder names/dropdown list of subfolders of selected folder/excel fil

    May be

    https://trumpexcel.com/list-of-file-...lder-in-excel/

    This link will help you
    If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Reply With QuoteRegister To Reply
  3. 12-11-2019, 04:17 AM #3
    Pepe Le Mokko
    Pepe Le Mokko is offline
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,452

    Re: Dropdown list of folder names/dropdown list of subfolders of selected folder/excel fil

    Links to 3 cross posts were added
    Last edited by Pepe Le Mokko; 12-11-2019 at 04:56 AM.
    How to paste Power Query code ( by Olly)
    Reply With QuoteRegister To Reply
  4. 12-11-2019, 04:20 AM #4
    adokskel
    adokskel is offline
    Registered User
    Join Date
    08-05-2010
    Location
    Ankara, Turkey
    MS-Off Ver
    Microsoft 365 MSO (Version 2209)
    Posts
    16

    Re: Dropdown list of folder names/dropdown list of subfolders of selected folder/excel fil

    Hello Shukla
    I already checked that post yesterday but that does not fit to my purpose even I can not adapt it to me.
    Thanks for your interest.
    Reply With QuoteRegister To Reply
  5. 12-11-2019, 04:36 AM #5
    Pepe Le Mokko
    Pepe Le Mokko is offline
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,452

    Re: Dropdown list of folder names/dropdown list of subfolders of selected folder/excel fil

    Links have been added
    Last edited by Pepe Le Mokko; 12-11-2019 at 04:56 AM.
    Reply With QuoteRegister To Reply
  6. 12-11-2019, 04:37 AM #6
    adokskel
    adokskel is offline
    Registered User
    Join Date
    08-05-2010
    Location
    Ankara, Turkey
    MS-Off Ver
    Microsoft 365 MSO (Version 2209)
    Posts
    16

    Re: Dropdown list of folder names/dropdown list of subfolders of selected folder/excel fil

    Hello Dear Admin,
    Sorry for my fault.
    I will add the links to my first post immediately.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] list of subfolders in folder - without files and sub-subfolders
    By MartyZ in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-11-2022, 10:56 AM
  2. Help Copy files from one folder and subfolders to another based on a list in Excel
    By inasr in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-30-2019, 03:47 PM
  3. How to put names of files in a folder onto a list in excel
    By jjwong in forum Excel General
    Replies: 1
    Last Post: 02-15-2016, 11:32 AM
  4. List of files in selected folder and subfolders
    By Un-Do Re-Do in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-09-2015, 04:52 AM
  5. list subfolders and files of main folder with details
    By buerere in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-21-2014, 10:44 AM
  6. Adapt macro to create list of all PDF files in folder, including subfolders.
    By Glensafro in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-23-2013, 06:33 AM
  7. list excel files when a folder is selected
    By Aishashk in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 04-12-2013, 07:08 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1