Using VBA how do you close a user defind workbook after you have extracted data

I have created a button call that lets the user select the desired xls file. The command then opens the file and takes data from column B and does a paste special (transpose) into the orignal workbook (Drawing Redlines.xls). The problem I am having is the user defind file will never have the same name. How do I setup the code to close the macro opend workbook once the data has been extracted?
If I define the file it works fine but the file name will never be the same hence the problem.

These are some sample files
DRAWING REDLINES.xlsmDWGLST.xls

And here is the whole code as of now:

Please Login or Register  to view this content.

This is the part I am having problems with:

Please Login or Register  to view this content.

Any help would be appreciated. I have been looking on this forum and others but I have not been able to find anything so I am posting my qquestion.
Thanks in advance

Something like this

Please Login or Register  to view this content.