Hello to All!!

Recently i had an requirement where i need to pull data from a closed workbook. I did some research and found a code from the website(link pasted below) :-

http://www.ozgrid.com/VBA/ExtractFromClosedWorkbook.htm

The code is just what I wanted; but now I have a new requirement. I need to auto open the file at some fix interval of time and after the macro is excecuted I want to close it automatically.


Please help, I have been looking for the solution for the past few days now but not able to achieve the desired result.

Thanks,