Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Programming / March 2005

Tip: Looking for answers? Try searching our database.

Controlling Screen Updating

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
RWN - 09 Mar 2005 03:14 GMT
Is there a way to stop the screen from "bouncing" around using the screen updating
function?
I can do it in Excel but Word is leaving me a little perplexed.

I have, for example, a macro that is re-setting some printer functions for all doc files
in a selected directory, as follows;

Private Sub FixPtrSource()
For f = 1 To NoOfDocs
   Documents.Open FileName:=TgtDir & DocFile(f)
   Set AD = ActiveDocument
   With AD.PageSetup
     ' Make the changes
   End With
   AD.SaveAs FileName:=TgtDir & DocFile(f), addtorecentfiles:=False
   AD.Close
   Application.StatusBar = "File " & f & " of " & NoOfDocs & " -> " & DocFile(f)
Next
End Sub

I have tried locating "Application.ScreenUpdating = False" in different sections of the
macro but it still flip-flops when the doc is closed and the next is opened and renders
the StatusBar unreadable.

Ideally I want it to have only the StatusBar updating.

Signature

Regards;
Rob
------------------------------------------------------------------------

Word Heretic - 14 Mar 2005 03:21 GMT
G'day "RWN" <NotLikely@mts.net>,

As you are openning and closing docs, you need to use Visible:=False
when you open them to prevent screen flashing.

Steve Hudson - Word Heretic

steve from wordheretic.com (Email replies require payment)
Without prejudice

RWN reckoned:

>Is there a way to stop the screen from "bouncing" around using the screen updating
>function?
[quoted text clipped - 21 lines]
>
>Ideally I want it to have only the StatusBar updating.
RWN - 15 Mar 2005 05:21 GMT
Thanks "Heretic"
You've just saved a few people from having seizures (typically there's about 400+ docs
that have to be re-set)!

Signature

Regards;
Rob
------------------------------------------------------------------------

> G'day "RWN" <NotLikely@mts.net>,
>
[quoted text clipped - 33 lines]
> >
> >Ideally I want it to have only the StatusBar updating.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.