Thanks gimme. See my comments below.

" wrote:

You didn't mention what web server you're using, IIS or what? And also
what OS your server is running.

I fathom that the recommended Microsoft solution is to use Microsoft
Report Server.
...
Another approach, if you have Server 2003, is to recreate the Excel
application as web application via Sharepoint...

Yes, it would be nice to be able to consider more Microsoft solutions. The
web server is running Tomcat on Linux. Report Server, Sharepoint, etc. are
not an option at this point (politically, support wise, and project $$).

I googled microsoft.public.inetserver.iis and seen where someone
attempted to create a VB com object and to wrap Excel in it. They still
had the issue though of being prompted to save or open upon startup.

I thought I saw something out there. I'll post a solution if I find one.

I'm guessing but I think that you'll either have to stick with the
shared drive solution or that the solution will be to rewrite the
application in ASP.


That's what I'm afraid of :(


And oh yeah, since the application is an Excel Worksheet, have you
considered adding a new email distribution Worksheet in your local
AddIn and having Excel send the emails from a single Sub?


Have considered something like this, but this will not solve many
maintenance and support issues. If I go this route, I have considered writing
a Version Control utility (or is there free-ware or OpenSource on this??) to
help keep workbook changes in sync.

Thanks again!