Need help with refreshing external data from a csv file every second

Someone help me just to fix the code. I recorded a macro, i clicked several times on refresh, and got this code:

Sub Macro1()
'
' Macro1 Macro
'

'
ActiveWorkbook.RefreshAll
ActiveWorkbook.RefreshAll
ActiveWorkbook.RefreshAll
ActiveWorkbook.RefreshAll
ActiveWorkbook.RefreshAll
End Sub

Someone could,complete this VBA macro for me in a way it loops forever? It would do. or it works for a certains amount of time. I just need the remaining code, because this
works for like only a second, i need it to work in loops, or certains amount of time..

Thanks for helping

Or it could be repeated this code above, every x time, like 1 second, it's better than infinite loops. I just need someone to complete the code for me, for a programmer is really easy

Originally Posted by coringa

Thanks a lot Daniel, you're the best. Helping others just for kindness. I tried first, the code workd perfect after deleting the if timer part. Thanks again wish you great new year

No problem friend.

Just put it as solved and i'm glad it helped you.

Great year as well.

Regards,
Daniel