1) Use functions like Dir (read the help files) and a string variable to hold the path and another to hold the returned filename.
This will give you a filepath and a filename to use in step 2

2)
You can import via Access (if you are using that) import (I think it is docmd.transferstext or docmd.transferspreadsheet).

Or you can open an instance of excel and loop through the cells with the data in.
More coding, but possibly better/more flexible.