Hi, I try to develop a excel automation in Visual Basic
6.0. This com will run in a server.
I don't know, which is the best way to do this.
If a develop a dll, The space of process is the same of
the client. This will cause that behavior of component is
locked the server.
If a develop a activex exe, it's will cause performance
penalty.
Please help to choose the best option, consider that the
client are more than to 50.000.
I read this:
http://www.*-*-*.com/
asp
It's posible automation word?
thanks.

I'm not sure what you're trying to accomplish, so this
suggestion may not make sense, but have you considered
creating a server process that handles the Excel
integration and submitting requests that that 'server'
using MSMQ?  This would allow you to support more users
(although 50,000 is a big number) while saving on server
resources.  Theoretically, it would even be possible to
scale the Excel processing out to multiple servers to help
with the work load.  I've used similar techniques to
submit requests to an application running in FoxPro on a
server separate from the web server, and the response time
was quite acceptible.

Bruce Johnson
TAG Consulting