Prompt for the user to select folder

Hi,

I'm new to VBA but have managed to write a macro to input certain lines of text files into a workbook, with each file creating a different worksheet. However, to change the location of the folder in which the files are found I need to change the code; although this isn't hard, my spreadsheet will be used by a few people so to make it more user friendly I want to calling up a dialogue box so the user can search through the directory and select the folder where the files are found.

So far, I've managed to get it so that the folder is found but I can't then get it to search through this folder and use the files within. Any help would be greatly appreciated! I've put the relevant section of the code below, but it keeps stalling at the statements:

Please Login or Register  to view this content.

Thanks for the help!


=======================================================

Please Login or Register  to view this content.