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

(SOLVED) I'm new to VBA on Excel, but i really need the program to refresh automatically the data from a dynamic CSV file that continuousily change it's values. It works fine on excel, but it's limited to <1 minute until the new refreshing. I tried different codes for VBA, found on searches with the same problem, but nothing happens when i run the macro. I would like to refresh like every 1 second. Someone here perhaps can show me a code on vba to make this refresh every second? I really appreciate

Greetings,

Dim Timer As Boolean 'put this at the beginning of the Module

Sub RunEveryFiveSecs()
    Dim seconds As Long
    seconds = CDate(Format(Time, "ss"))

    MsgBox seconds 'Can remove the Msgbox because it will be annoying as well as what's in RED
    If Timer = True then
    ThisWorkbook.RefreshAll
    Application.OnTime Now + TimeValue("00:00:05"), "RunEveryFiveSecs"
    End if
End Sub

Sub StopIt()
    'If you want it to stop after you close the workbook, then put this in the event workbook close
    'Call StopIt
    'Can also be used in a button to stop the loop
    Timer = False
End Sub

Sub StartIt
    'Use this for some button or something like that to start the loop
    Timer = True
    Call RunEveryFiveSecs
End Sub

Maybe this will help.

Regards,
Daniel

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