Excel: how to get macro to pause for fil

I wish to create a macro that includes opening a file. The macro recorder will do this but hard codes the particular file name in the code. I want the macro to pause and give me the option to select the file to be opened, and then continue after I have selected. I used to be able to do this with Lotus so am sure that Excel can too.