How to run an applcation at fixed intervals when enabled.

I am designing an application which has two main parts.
The first part takes data from an ODBC llnk, manipulates it and sends it out as a text file. This textfile is used by another application (not in excel)

The other application generates a second text file and this is copied into a worksheet of my application and used as a feedback.

My problem is that I need to run the second operation many times per day, but I can only run the main application once a day.

What I would like to do is to automaticaly run the second operation say once a minute, then disable this while I am running the main application.
I have not been able to find a way of doing this and would be grateful of some help

Regards
John

You can start with the below and adjust it to your needs
Put the below in a fresh module , Sub startingtimer is what you call when you decide to do you small import to compare.

Please Login or Register  to view this content.

hulpeloos,
I have been working on your solution to my problem, and have now got bit working. It does just what I need. Thanks for your interest and help
John