I
Ian Elliott
Thanks in advance.
One of my work duties is to run an Excel VBA macro that
inputs values from a file. I do this once a month, at the
beginning of the month (around 7th or 8th or so). I can
run the macro as soon as the input file is put in a
certain directory. I would like to make a program that
checks the directory to see if the file is there (rather
than me being told by my boss to do it or me checking
every day). I figure the most efficient way to do this is
to have Windows Explorer check there every day or hour or
some other time unit (if this is possible, but I don't
think I can write macros for Windows Explorer), or have
Outlook check (I always have Outlook running in the
background on my computer, as I want to be notified right
away if a coworker sends me a message. So, I figure
putting a macro in Outlook might be efficient, since I
already have Outlook running).
Does anybody think this is a good way to go?
All input appreciated.
Thanks again.
One of my work duties is to run an Excel VBA macro that
inputs values from a file. I do this once a month, at the
beginning of the month (around 7th or 8th or so). I can
run the macro as soon as the input file is put in a
certain directory. I would like to make a program that
checks the directory to see if the file is there (rather
than me being told by my boss to do it or me checking
every day). I figure the most efficient way to do this is
to have Windows Explorer check there every day or hour or
some other time unit (if this is possible, but I don't
think I can write macros for Windows Explorer), or have
Outlook check (I always have Outlook running in the
background on my computer, as I want to be notified right
away if a coworker sends me a message. So, I figure
putting a macro in Outlook might be efficient, since I
already have Outlook running).
Does anybody think this is a good way to go?
All input appreciated.
Thanks again.