Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Avoid "update Links" promt in e-mailed pivot tables? | Excel Discussion (Misc queries) | |||
How do I avoid "Missing PDFMaker files" error? | Excel Discussion (Misc queries) | |||
Text formatted as "General" in Excel 2002. How do I avoid that? | Excel Discussion (Misc queries) | |||
How to avoid "update links" startup prompt? | Excel Discussion (Misc queries) | |||
"WinForm Application" to act as "RTD Server" using .Net | Excel Discussion (Misc queries) |