G
Guest
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
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