Start a Macro when a file exists

[Jason Zischke]

Hi All

I was wondering if this is possible if you could have a file sitting doing
nothing but when a file is added to a certain folder to startup a macro?

Jason

 

[JLGWhiz]

Don't know it that event is covered at this site, but Chip Pearson covers a
lot of events that might give you some insight.

http://www.cpearson.com/excel/Events.aspx

 

[Jason Zischke]

Hi JLGWhiz

Thanks for your responce, however I'm still a bit of a novice when it comes
to class modules. Any help would greatly be appreciated.

Jason

 

[Tim Williams]

Look at

Application.onTime to schedule a repeating macro
Dir() to check the contents of a folder

Tim.

 

[Jason Zischke]

Hi Tim

Thanks for your responce, however that won't work to well for me, because
the files that go to that folder can be irregular which means you may have to
wait a bit more for some and not others.

Jason

 

[Tim Williams]

So if the workbbok was scanning the folder for new files every minute that
wouldn't work ?

It is possible to put a "watch" on a folder but that's a bit more complex:
http://vbnet.mvps.org/index.html?code/fileapi/watchedfolder.htm

Tim

 

[Jason Zischke]

Hi Tim

Thanks for your responce, I got the watch on a folder ot work for me and it
seems to be doing well, Thanks

Jason

 

[Dave Peterson]

Not doing nothing...but how about continuously monitoring a folder?

You may want to look at Randy Birch's site:
http://vbnet.mvps.org/index.html?code/fileapi/watchedfolder.htm