Remote shut down of Excel

[;-\)]

Something that I did realize was that the excel workbooks that are giving
problems are the ones where my function forces a user-form to open and it
stays open until the workbook closes.

So there maybe an event I need to set to clean up the shut down?

Any thoughts?

 

[keepITcool]

show the user forms Modeless.

then you have no problems closing the running books
or instances.

also..
WHY are you running 20 excel INSTANCES?
iso 1 instance with 20 workbooks?


keepITcool

< email : keepitcool chello nl (with @ and .) >
< homepage: http://members.chello.nl/keepitcool >

 

[;-\)]

Thanks, I will try it after my coffee.

I have 20 production/product lines. Only one line is run at a time. Each
has 1 to 5 excel workbooks. I just chose this method because it was the
first one I tried and now I don't want to mess with a working application.

The user can watch any of the excel sheets working this way, and if any dies
the others are not effected. These are (mostly) created by the clients
engineering dept with various levels of programming knowledge.

My next product line (the last) will combine ~8 linked(altho local)
workbooks into one with a user interface and the remote control function
listed here.