VBA Changing a fixed file path with open file dialog box

Hello

Hoping someone might be able to help. I've recorded a macro in excel to import a text file. After a bit of tinkering with the code all works well. The only thing is now it imports the same txt file every time. I'd like to be able to be prompted for the file location before the rest of the macro runs rather than altering the code each time. I've popped my code in below if it helps.

Thanks

Dan

Please Login or Register  to view this content.

Dan
Does this help

Please Login or Register  to view this content.

where sFName is a string variable to plug into your code

barry