User select folder name

M

MJKelly

Hi,

I have a number of csv files which I import into a spreadsheet. This
all works fine, but I have hardcoded the name of the folder which
contains the csv files. How can I share this spreadsheet with my
colleagues and allow then to put their CVs files anywhere on their
system, and simply have excel use the open file dialogue to let them
navigate to the correct folder? I don't want them to have to select
the files (as there will be many csv and other files in the folder).
I just want to capture the path of the folder they choose and have
excel use this to import the csv files.

Thanks,
Matt
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Open my default template when right click, select New MS Word doc within a folder 0
Shortcuts in OneDrive 0
Sub projects added as read only in Master file which are saved on sharepoint 1
Synchronization problems while moving folders to new email 1
CSV files and having numbers and strings in there... 9
Cannot open any folders (pinned or recent) from Word 365 Open Dialogue/Backstage 0
Search macro for greater than 100000 on multiple CSV files 1
Excel VBA macro to auto import new CSV file from fixed directory 1

Top