Code that looks for directory then remembers the directory location after that.

I have code that when you run it asks you to select the file you want information pulled from and then it places it where you want it.

Can you change it so the first time you run it it asks for the location of the file and uses it
then after that it remembers the files location and you don't have to select it anymore it will always be in that directory once you select it (I have to choose it first because the directory is not always in the same spot to start, but after the first run it should be in the same place.

This works as of now by selecting the file every time.

Please Login or Register  to view this content.

Thanks for the help. It worked like I wanted it to....the problem is someone asked for a change so now I need to modify it. The source directory that file will be in can change from time to time.
So what we would like is i will create another button for macro but on this code for the macro i need for the user to set the source directory at the start or when it needs to be changed they can do it at anytime.
Then the code you just gave me will utilize that source directory and you can choose the file within that directory just like it is now. Sorry for the change up but this will help others too.

Again thanks for your reply.

I have tried to get that to work with no luck can you help with details within the code i used from protonLeah.......thanks for your help