View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Stefan Stefan is offline
external usenet poster
 
Posts: 27
Default how can I avoid "server busy" message during ole automation

Hi all,
I us rational robot (SQA Basic, kind of VB) and change some data in excel.
afterwards I want to save Excel. That´s when the "server busy" message
appears.
"This action cannot be completed because the other program is busy. Choose
"Switch To" to activate the busy program and correct the problem."
It´s not a problem with smaller files.
I used the application.DisplayAlerts = False, but this doesn´t help.
I found something about OLEServerBusyTimeout, OLEServerBusyRaiseError and
OLERequestPendingError but I get a compiler error. It looks like they not
supported by Excel. how else could I change this timeout?

thanks in advance.
Stefan

the relevat parts im my code are as followed:
Set mobjExcel = CreateObject("Excel.Application")
Set objWorkBook = mobjExcel.Workbooks.Open(FileName:=strWorkBook)

(operation with excel)


If not objWorkBook Is Nothing then
objWorkBook.Save ' after this command I get the "server busy"
message
objWorkBook.Close
End if