Posted to microsoft.public.excel.programming
|
|
Temporarily stop script
I think Mat's concept is a much better one. Perhaps he will share with you
how to implement it.
--
Regards,
Tom Ogilvy
"H.A. de Wilde" wrote:
Dear Tom,
The loop works but is not working fine.
When the Word-document is minimized or there is a switch to another
application, the system does't perform good. Alos the return to Excel
is very slow. I think the loop is too risky. Sometimes an error
occurs.
Dear Cheers,
Pasting the text:
Private WithEvents g_oApp As Word.Application
Private WithEvents g_oDoc As Word.Document
into a module, it turns into red.
Thanks for your replies.
Kind regards,
Hugo
--
H.A. de Wilde
------------------------------------------------------------------------
H.A. de Wilde's Profile: http://www.excelforum.com/member.php...o&userid=30679
View this thread: http://www.excelforum.com/showthread...hreadid=538800
|