Add question if you need to change the source directory (File) first then run code.

The problem with the code is The source directory (File) the user points to might change from time to time.

I need for the user to be able and change source directory (File) when it needs to be changed.

Once you run it now it works but if you need to change where the file is located you cant its all automatic.

Maybe a pop up question at start saying do you need to change the source directory if user says "no" then it proceeds on
but if they say "yes" then it jumps down in code to where they choose the directory (or File).
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.

Please Login or Register  to view this content.

I added the addition but now when I choose the file location i get an runtime error, it says automation error and unspecified error...i highlighted the section it directed me too.

Please Login or Register  to view this content.