+ Reply to Thread
Results 1 to 4 of 4

Prompt user for folder to browse and read only the .wav files

  1. #1
    Registered User
    Join Date
    05-20-2020
    Location
    USA
    MS-Off Ver
    10
    Posts
    28

    Prompt user for folder to browse and read only the .wav files

    Hello,

    I am attempting to add a popup window to ask the user for a "Browse" window, then use that folder path
    as the "myfolder" variable to be used to get the file names that reside within the folder.

    How do I go about only getting the .wav file names from the folder?


    Here is the code that I have:

    Please Login or Register  to view this content.
    Last edited by jimjones1958; 04-21-2021 at 01:39 PM.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Prompt user for folder to browse and read only the .wav files

    Probably the easiest fix for this code is
    Please Login or Register  to view this content.
    I probably would have used Dir instead of the file utility, which can filter it for you up front.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    05-20-2020
    Location
    USA
    MS-Off Ver
    10
    Posts
    28

    Re: Prompt user for folder to browse and read only the .wav files

    Hello,

    Thank you for your quick solution!

    Can you share your code on your Dir approach?

    Thanks again!

  4. #4
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Prompt user for folder to browse and read only the .wav files

    I would have to extensively re-code your VBA to do it. The concept is that Dir cycles through files in a folder matching a wildcard, something like this:

    Please Login or Register  to view this content.

+ 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. Prompt User Folder Location and Store as Directory for Creating Folders
    By kozman2 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-06-2017, 04:58 PM
  2. Open Folder (Prompt User for final folder name in location path)
    By synergeticink in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-21-2014, 03:33 PM
  3. Disable save prompt for all files in current folder?
    By GregTheSquarePeg in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-09-2014, 09:37 AM
  4. Replies: 1
    Last Post: 11-12-2013, 03:44 PM
  5. [SOLVED] Macro to prompt user for folder location and save acitve workbook.
    By maacmaac in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-06-2013, 06:20 PM
  6. Prompt User for Directory(folder)
    By cocotrp in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-14-2011, 06:37 PM
  7. Prompt for the user to select folder
    By Pomme in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-20-2010, 11:47 AM

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