Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Program Excel to run a procedure several days in a row
|
|
|
The UK's most regular Training information: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Program Excel to run a procedure several days in a row
Resolved · Medium Priority · Version 2010
Reply Tue 3 Jan 2012, 10:09Delegate Alain said...
Alain has attended:
Excel VBA Intro Intermediate course
Excel VBA Advanced course
Access Introduction course
Access Intermediate course
Access Advanced course
Access VBA course
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
For upcoming training course dates see: Pricing & availability
RE: Program Excel to run a procedure several days in a row
Hi Alain
Happy New Year to you and thanks for the post. We have certainly scratched our heads over this.
What we can say is that if a solution is available it will be something we need to look at beyond this forum.
This will be consutlancy work to research and design a solution for you with associated costs. If you would like to progress this please reply to my email.
Kind regards
Jacob
|