I need to have a workbook created which does the following on open:
1. downlaod a .zip file
2. extract the .xlsm file from the .zip file
3. open the downloaded .xlsm file
4. close the original file that the macro we just ran from
I want all of this to happen in a somewhat hidden fashion if possible. Within the macro I need to be able to define the URL from where the item will be downloaded. For a test example please use the following URL:
[url removed, login to view]
Let me know if you have any quetions.