Macro to open a file with a name that changes

[SandsB]

My input file has a date/time stamp in the filename. I manually open the file and copy the rows of data (everything but the headers in row 1) and paste them into another file with the macro I use to create a report. I know how to tell a macro to open a file if the file name never changes but how can I tell it to let me point to a file if the name isn't the same every day? I need it to give the user a pop up that says something like "point to the input file."

 

[footoo]

Application.GetOpenFilename method (Excel)

Office VBA reference topic

learn.microsoft.com