If I recall correctly, Randy Birch uses a userform (albeit VB, not VBA) to show
how this works.

You may want to post more info about what you tried. (I remember it working in
2002 when I was using xl97 SR2 and win98.)



SIGE wrote:

Hi There,

I would like to verify whether there are changes on a certain
text-file.
Dave P. gave a link to the site of Randy Birch where he has some code
which does -i think- exactly what I would like to test.

I created the Userform ...Commandbuttons ..labels ...as he suggested.
But do not succeed to get any data in it.
Is it not possible to fire this code in Excel97 SR2? Why?
If possible: How?

Sige

Van:Dave Peterson
Onderwerp: Polling a directory for changes with Excel
Datum:2002-03-01

I'm not quite sure if this is what you want, but you can get some code
from
Randy Birch's VBNet site to use API
calls to watch a folder.

Go to http://www.mvps.org/vbnet/ and
search for FindChangeNotification.

--

Dave Peterson