Pause macro whilst selecting the file i want to copy from

hi,

i will have many workbooks with data in it in a folder called "accuscan temp" that i will want to copy to another workbook, then do other things with the data copied.

the file path i have is

 ChDir "C:\Users\steve.kirk\Documents\accusacn temp\results"
    Workbooks.Open Filename:= _
        "C:\Users\steve.kirk\Documents\accusacn temp\?????????


Cells.Select
    Selection.Copy
    Windows("results table.xls").Activate
    Sheets("Sheet1").Select
    Cells.Select
    ActiveSheet.Paste
    Range("A6").Select
    Application.CutCopyMode = False
    ActiveWorkbook.Save
    Sheets("Sheet2").Select
    Windows("sheet1.csv").Activate
    Range("P11").Select
    ActiveWindow.Close

is it possible to pause the macro until i click on the file i want before it resumes with the macro

then name the file that i have copied the data to the same name as the data come from


thanks

steve