Hi Joseph,
Check out Application.OnTime. Your structure would be something like:
Private m_nNextTime as double
Sub CheckFile()
' Code to check whether the file has changed
m_nNextTime = Now + TimeValue("00:00:03")
Application.OnTime m_nNextTime, "CheckFile"
End Sub
BTW you need to store the time the routine will next run so that you can
turn off the timer at the end.
HTH
Peter Beach
"Joseph " wrote in message
...
Thats just the job,
Now is there any way to do this after a specified amount of time?
i.e. I want excel to check the size of the file after about 3 seconds,
and if it finds that the file size has changed then it should output
the new code. I've been fiddling around with Filelen() and timer() but
can't get my limited brain around it!
Cheers
---
Message posted from http://www.ExcelForum.com/