Getting a macro to run every so many seconds

[ExcelFailure]

Hi there,

I have the following macro

Sub Refresh()
'
' Refresh Macro
'


'
    ActiveWorkbook.RefreshAll
End Sub

How can i get this to run in the background every 30 or so seconds?

Thanks

 

[CodeNinja]

Use the application.ontime function...

Application.ontime now + timevalue("00:00:30"), refresh()

 

[ExcelFailure]

Sorry, bit of a noob - how exactly do I do this? Thanks

 

[CodeNinja]

See this thread to get a bit more detail:

http://www.mrexcel.com/forum/excel-questions/64257-application-ontime.html