ms excel is waiting for another application to complete an OLE act

[waiting to complete an OLE action]

In an MS Excel 2003 code module I have a process that does a binary reed on a
text file and converts it to a tab delimited file. The process takes a long
time and causes a dialoged box to appear with the message Microsoft office
excel is waiting for another application to complete an ole action. This
causes the execution of the code to stop if the OK button is not clicked.

Is there a way to suppress this message so the code execution is not
interrupted when no one is present to click the OK button?

 

[Cindy M.]

Hi =?Utf-8?B?d2FpdGluZyB0byBjb21wbGV0ZSBhbiBPTEUgYWN0aW9u?=,

In an MS Excel 2003 code module I have a process that does a binary reed on a
text file and converts it to a tab delimited file. The process takes a long
time and causes a dialoged box to appear with the message Microsoft office
excel is waiting for another application to complete an ole action. This
causes the execution of the code to stop if the OK button is not clicked.

Is there a way to suppress this message so the code execution is not
interrupted when no one is present to click the OK button?

Since you haven't gotten a response here, you might try asking in the
excel.programming newsgroup.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail