Prompt user to select file to import

Good Afternoon,

I'm trying to create a macro (piece by piece) to enable my most novice excel user to accomplish a fairly advanced task. (Basically, I'd like all of the more complex tasks done behind the scenes with this macro).

The next step in my quest is prompt the user to select a file from a specific file location. I recorded myself going through the motions, but my code obviously specifies a specific file name......but the file name will vary from day today.

For example, my code below references a file name called "ARS Deposits - 101609.txt".....but tomorrow's might use a different date.

Can I insert an interactive menu/box that will "stop" the macro and allow the user to manually select which file to import? Does this make sense?

Here is my code (the section I'm referring to is colored red):

Please Login or Register  to view this content.

Where would I paste the code?

I think I understand. I confused myself because I'm using a different machine now...ugggh

I'm going to play around with it. I appreciate your help and patience