Error in VB Automation Application

[Renjith]

Hi There,

I am using VB6 and Microsoft Office 2003. I have written an application for
automating some tasks in MS Word. The program is executing in a loop and
gives a message:
*Word has insufficient memory. You will not be able to undo this action once
it is completed, Do you want to continue?* with options Yes and No. I am
clicking Yes. Then the program runs for the rest of the loop and Hangs. Whn I
click on the Application or the VB IDE, I get the following error:
*This action cannot be completed because the other application is busy.
Choose 'Switch To' to activate the busy application and correct the problem*
with options Switch To and Retry. What ever option, I select the message
appears again. I searched on some newsgroups and found a solution to add
App.OleRequestPendingTimeout = 99999 at the beginning of my code. But this
also didn't solve my problem
Please help me it is urgent.

 

[Cindy M -WordMVP-]

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

It sounds as if you're trying to do a lot of formatting, without either clearing
the Undo list, or performing a Save action, thus allowing Word to clear its
"scratch files".

I am using VB6 and Microsoft Office 2003. I have written an application for
automating some tasks in MS Word. The program is executing in a loop and
gives a message:
*Word has insufficient memory. You will not be able to undo this action once
it is completed, Do you want to continue?* with options Yes and No. I am
clicking Yes. Then the program runs for the rest of the loop and Hangs. Whn I
click on the Application or the VB IDE, I get the following error:
*This action cannot be completed because the other application is busy.
Choose 'Switch To' to activate the busy application and correct the problem*
with options Switch To and Retry. What ever option, I select the message
appears again. I searched on some newsgroups and found a solution to add
App.OleRequestPendingTimeout = 99999 at the beginning of my code. But this
also didn't solve my problem

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
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

 

[Renjith]

I was clearing the Undo List using the *UndoClear* Method. but I haven't
saved the file in between. Let me try it and update you. Thanks for your
advice.

regards,
Renjith