[AccessD] Access Reporting Application - Dealing with Excel Input Files that are E-mailed Daily

Brad  - I ran into this EXACT situation at an investment banking firm.
Email attachments were effectively the data source.
So I created an Outlook Addin which effectively scanned each email that
arrived for keywords in the body or subject.
Then it took the attachment and placed it into a special network folder.
This mini-app was so cool...the users loved it...I even popped-up a timed
form which told them that particular email had arrived. I was going to add
logging as well, but never got to it. I did add the ability to UNZIP the
attachment...and that was slick as well. (They still were using XLS format
!)

P.S. Changing the name would be a piece-of-cake.

> Each day, a new Excel file is e-mailed to me.  I DO NOT have control
> over how this file is named.  When I receive the e-mail, I save the
> attached Excel file with a consistent name so that the nightly Access
> application can find it.  In other words, I save the Excel file with
> the
> name that the Access application is expecting to find.  This procedure
> works, but it does require manual intervention every day.  I would like
> to find a better method so that this manual intervention is not
> required.
>
> Has anyone else ever run into this type of situation?
>
> I have started to experiment with Outlook VBA code.  I have written
> quite a bit of Access VBA, but not much Outlook VBA.  I am not sure of
> the potential of this route.
>
> Any ideas or insights would be appreciated.
>
> Thanks,
> Brad