Program Excel to run a procedure several days in a row

Hi,

First of all I wish you a happy New Year.

I woud like to run an Excel application that is called REC_FORWARD_FX_EXPOSURE each morning. I use the following bit of code that I put in the module "ThisWorkbook" of the PERSONAL.XLSB file.

Private Sub Workbook_Open()

Application.OnTime TimeValue("06:00:00"), "REC_FORWARD_FX_EXPOSURE"

End Sub

In order to have this work I keep Excel open and do not shut down my computer when leaving the office in the evening. This procedure works very well but is run only once the next day. Therefore when I am off the application is run only once and no longer on a daily basis.

I would like to know how I could program Excel to execute it every day, that is to say several days in a row without closing and reopening Excel. Could you please suggest a solution?

I thank you in advance for your help.

Alain