Allow user to input directory to import from

I have been using VB for just under a month and this is the first time I've been completely stuck...
My current code goes like this

Please Login or Register  to view this content.

This is where I am having problems:

With ActiveSheet.QueryTables.Add(Connection:="TEXT;C:\Grekazor player role analyser\Reserve team.csv" _

I want to allow the user to define the directory. Maybe have something pop up where they can browse to the directory they have the "Reserve team.csv" file in. Is this possible? Thanks in advance!

Try this:

Please Login or Register  to view this content.

Good luck.

abousetta

I apologize I didn't notice you are using a Private Sub. I use this method for a Sub and it works fine. Maybe try puting this in a sub and then calling the private sub?

Sorry if I did more harm than good.

abousetta

Originally Posted by abousetta

I apologize I didn't notice you are using a Private Sub. I use this method for a Sub and it works fine. Maybe try puting this in a sub and then calling the private sub?

Sorry if I did more harm than good.

abousetta

No not at all, I have backups.
Any help is much appreciated.

As I said, im new to VB so basically I have no idea what you just said

Thank you so much both of you, especially for the quick replies.
I have it as this now:

Please Login or Register  to view this content.

The only problem with this is that the user always has to select the file.
There are actually 5 exact replicas of this formula except each one imports data from a different file (First team.csv, Reserve team.csv, U18 team.csv.......) but with a common directory. So it is actually the directory that I wish to allow the user to define. Is there a way to allow the user to define the directory just once when the workbook opens or upon clicking a "define directory" button and then just use their response that in the formula above?