Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

quieting Word down during VBA execution 1

Status
Not open for further replies.

RobBroekhuis

Technical User
Oct 15, 2001
1,971
US
I'm used to Excel's VBA, where an
Code:
application.screenupdating=false
will nicely hide any screen activity from the user. This doesn't seem to work as well with Word - it hides the in-document manipulations, but not any activity of the scrollbar or document switching on the taskbar, to a very distracting effect (and I'm sure it slows execution down).
My application pulls in many text files (each opened as a new document) and assembles them into one large document. So there is lots of switching going on. Any way to keep Word quiet?
Rob
 
Another method would be to set the WindowState to minimized so that the Word application it is still accessible from the task bar:
Code:
Application.WindowState = wdWindowStateMinimize
 
Dsi,
Yes, that's what I tried first. But the taskbar still bounces around a lot, since I'm constantly opening and closing files. On the other hand, the application.visible method causes an almost eerie silence on my PC. I wish I could just have Word sitting there with an hourglass pointer without any screen activity.
Rob
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top