View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 6,953
Default 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