Excel Programming >> Polling directory for changes
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:Re: 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.hide-link.com/
search for FindChangeNotification.
Excel Programming >> Polling directory for changes
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.)
>
> 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:Re: 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.
