I have a macro which pulls data out from a database and I would like it to refresh the data every 1 minute. Below is my macro, does anyone know what commands should I use to run this macro every 1 minute.
Sub StockPriceMain()
Sheets("Temp").Select
Call StockPrice("9915")
End Sub
Sub StockPriceMain()
Sheets("Temp").Select
Call StockPrice("9915")
End Sub