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 |
All times are GMT +1. The time now is 11:24 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com