Automatically run the macro every minute between specific time

[talhaparvaiz@yahoo.com]

Hello,
I've developed an Excel file that dynamically updates via an API with real-time stock data. My objective is to automate the process of pushing this data to MS Access every minute.
I've made progress on certain aspects of the task, but there are areas where I could benefit from expert guidance.
Here's what's currently not functioning as desired:

- The macro I've created needs to be executed manually. My goal is to automate this process so that it runs automatically every minute.

- When running the macro manually, I encounter messages prompting confirmation for data insertion into certain tables. I aim to eliminate the need for manual confirmation

- Additionally, I aim to restrict the execution of this macro to occur only between 8:30 AM and 3:00 PM Central Time.
I've included the macro and the Excel file for your reference.
Thank you for your assistance.

[Micron]

Insert a standard module (menu>insert>module). It should contain this:

Option Explicit
Public alertTime As Variant

Public Sub EventMacro()
MsgBox "test"
SetOnTime

End Sub

Sub SetOnTime()

alertTime = Now + TimeSerial(0, 0, 10)
Application.OnTime alertTime, "eventmacro"

End Sub

If you want workbook open event to trigger the code it should contain this:

Private Sub Workbook_Open()
Dim alertTime As Double

alertTime = Time + TimeSerial(0, 0, 10) 'this adds 10 sec. to time workbook opens for first run
Application.OnTime alertTime, "EventMacro"

End Sub

A msgbox should open 10 secs after workbook open, then every 10 seconds. If you can get that to work then the next steps can be figured out.
Note: you can do all the pasting, then paste this into the immediate window
Application.OnTime alerttime, "eventmacro", , False

You can then trigger the wb open even by putting your cursor at the beginning of the open event code and pressing F5. You should get the msgbox 10 seconds later.

When you want to stop the event, put cursor at the end of that line in the immediate window and hit Enter.
OR you can change the value from 10 secs to some other value if you want more time in between.

EDIT - your file must be xlsm. Next time, please upload xlsm when you want code, because xls files cannot contain vba (macros).