Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Avoid "update Links" promt in e-mailed pivot tables? Michelle B Excel Discussion (Misc queries) 2 October 23rd 06 02:54 PM
How do I avoid "Missing PDFMaker files" error? Kit Marty (CHM Consulting) Excel Discussion (Misc queries) 2 August 24th 06 03:58 PM
Text formatted as "General" in Excel 2002. How do I avoid that? Anant Excel Discussion (Misc queries) 4 August 11th 06 09:16 PM
How to avoid "update links" startup prompt? [email protected] Excel Discussion (Misc queries) 8 July 23rd 06 04:20 AM
"WinForm Application" to act as "RTD Server" using .Net mduraidi Excel Discussion (Misc queries) 0 March 30th 06 01:01 PM


All times are GMT +1. The time now is 07:31 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"