macro to locate and close workbook

hi guys,
I'm not great at macros so need some help from those who know. I need to copy information from a workbook to my sheet with the workbooks name changing slighltly. In have the following macro to do this part but I would like to close the workbook after pasting in the required data.

Also, as the workbook is generated from the web, I get a web page opening with it. I would also like to close this web page if possible.

To break it down
I export a file to excel format.
Use my macro to locate, copy and paste information
I need it to then locate the web page and book and close both

Please Login or Register  to view this content.

Please read forum rules & wrap your VBA code

A thread with the rules is available at the top of each forum

If you do not understand the VBA code wrap instructions have a look at my last reply in this thread
http://www.excelforum.com/showthread.php?t=583950