Controlling Instances of Excel Application with external application

S

sdgough

I have a various instances of a robust Excel XP application running on
server. They are always running (they service different clients in a
ASP web application) and they perform a variety of tasks (includin
reporting stats/usage to a SQL Server) and make extensive use of VB
and addins. Unfortunately the applications 'hang' once in a while an
logging into the server to close instances or restart them is a pain.
To that end, I am attempting to write a VB or VB.Net application tha
can interface with these applications (poll them, open new instance
with specified paths/files, shut them down etc.).

My question is this, does anyone have experience doing this sort o
thing? Is it even feasible? What are the pitfalls? One stumblin
block I have encountered already is determining which instances o
Excel are open. Another is communicating with them unless they wer
opened by the VB application itself. Do I have to shell the instances


Any insight would be very much appreciated
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top