View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Jason Zischke Jason Zischke is offline
external usenet poster
 
Posts: 147
Default Start a Macro when a file exists

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" wrote:

Look at

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

Tim.


"Jason Zischke" wrote in message
...
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