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 outpu
the new code. I've been fiddling around with Filelen() and timer() bu
can't get my limited brain around it!

Cheer

--
Message posted from http://www.ExcelForum.com