Check from Outlook or WExplorer if file exists.

  • Thread starter Thread starter Ian Elliott
  • Start date Start date
I

Ian Elliott

Thanks in advance.
I have an Excel VB file that uses another file as input. I
run this Excel VB file at the beginning (7th or 8th) of
every month. I run this file as soon as the input file is
available in a certain directory. Currently, my boss tells
me when to run the program or I check the directory to see
if the input file is available.
I would like to make a program that informs me
automatically if the file is available (or maybe even runs
the Excel VB file automatically when the input file is
available).
I figure I could attach a macro to Outlook that checks
every day or hour to see if the file is there. Or maybe
with Windows Explorer, although I don't know if I can make
macros in Explorer.
Does anyone think the Outlook method is the correct one?
Anyone have any experience in this?
Thanks again.
 
Outlook has no timing mechanism other than on startup to do that. Why
not write a script that checks for the file using Windows Scripting
and then use the task scheduler in Windows to run the script as often
as you want. The script could then launch Excel or an EXE that runs
your code.
 
Back
Top