Start a Macro when a file exists
 

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

Start a Macro when a file exists
 

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

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

Start a Macro when a file exists
 

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

"JLGWhiz" wrote:

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

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

Start a Macro when a file exists
 

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

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

Start a Macro when a file exists
 

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?cod...chedfolder.htm

Tim


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

Start a Macro when a file exists
 

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

"Tim Williams" wrote:

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?cod...chedfolder.htm

Tim


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

Start a Macro when a file exists
 

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?cod...chedfolder.htm



Jason Zischke wrote:

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

--

Dave Peterson