Greetings,
I am interested in building a subroutine that imports external data from using a web query on a cyclical basis, one day, one week, one month, or one quarter. I would like to know if anyone has experience in doing this and if so how might be best to structure the block of code that determines the time to execute the subroutine. I would like to be able to have the subroutines execute automatically so that I don't have to manually click buttons to update the retrieved data. Is it possible to do this with excel closed, or do I need to keep a workbook open to enable the execution of subroutines on timers?
Thanks!
I am interested in building a subroutine that imports external data from using a web query on a cyclical basis, one day, one week, one month, or one quarter. I would like to know if anyone has experience in doing this and if so how might be best to structure the block of code that determines the time to execute the subroutine. I would like to be able to have the subroutines execute automatically so that I don't have to manually click buttons to update the retrieved data. Is it possible to do this with excel closed, or do I need to keep a workbook open to enable the execution of subroutines on timers?
Thanks!