Monitoring a directory? Importing excel files

[laurco]

Hi all,
I have a function set up in Access to import data from excel files.
To do this, I send the file name as an argument and run the code.
This is easy enough when it's only a few files, but since I have over
100 I'm looking for a way to streamline this process.

Is is possible to set something up to monitor a directory, and run the
code when a new file is placed there? Or any other ideas?

Thanks in advance, I really appreciate any insight.

 

[Douglas J. Steele]

Check what Randy Birch has at
http://vbnet.mvps.org/code/fileapi/watchedfolder.htm

Obligatory warning: Randy's site is aimed at VB programmers. There are some
significant differences between the controls available for forms in VB and
in Access, to the point where some of his samples will not port directly to
Access. I didn't look too closely at this particular example, but I think it
should port alright.