View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Max Crosse Max Crosse is offline
external usenet poster
 
Posts: 1
Default OLE Automation - Server busy message

I am craeting an instance of an Excel application in my VB
code. If I leave Excel open for more than 5 seconds then
try to close it and return to my VB app I get the
following Server Busy error:

This action could not be completed because the "Microsoft
Excel" program is not responding. Choose "Switch To" and
correct the problem.

Does anyone have any idea how to stop or configure this
message from appearing. It does not happen if you close
the Excel application within 5 seconds which to me
indicates some sort of timeout listening event.

Any help would be much appreciated!

Max