I am looking to refresh a DB import within a macro but I am not sure how to get the time of the last refresh. Could someone point me in the right direction.

Also, is there a way to set a macro to run at given intervals or is a worksheet calculation the best way to do it?