I wouldn't use excel for this because it ties up Excel,
and it eats up CPU cycles.

Instead, I would write a VBScript and set it up
as a scheduled task to run every 10 minutes.
You can even have it only run during certain time of day.
Also, you can even write to a log file every time it runs
so that you can check the log at any time.

I understand your point.
I have never written a VBScript, so I have to look at that, but I
have a clue, that its close to vba?
My code is as mentioned checking for new files (.csv) in a folder, if
found reads the file (testdata) into an array and distribute the
datas to an access database.
Is that doable from the VBScript? Maybe a silly question but I know
nothing about it!

It is close to VBA but the biggest thing to note is that there is no
host application, so if you want to work with an Office application, you
have to connect explicitly to it, there is no implicit Application.

You should also note that variables are not typed at declaration, they
are all variants, so just do something like

Dim myNum
Dim myString

etc.

I am very interested about your application on how to use timer in
Excel application.
Could you give me some examples for this case? thanks a lot!

Nothing much to learn from here.
Just used the Application.Wait method (check out the help for that).
"it ties up Excel, and it eats up CPU cycles". At least the
excel session from where it is running is occupied.