Re: Converting documents

Hi Leu,

It's usual to have a line like
Application.ScreenUpdating = False
at the beginning of the code to stop/reduce screen flickering. It also speeds up processing, sometimes quite a lot, as Word doesn't have to redraw the screen for each change. At the end, you then run:
Application.ScreenUpdating = True

Even without those lines, however, PCs with slower CPUs and/or graphics cards might give the appearance of inactivity.

To give some feedback on the code's progress where execution could take a while, it is therefore common practice to provide feedback, either by way of updates on the status bar or via a progress indicator.

--
Cheers
macropod
[MVP - Microsoft Word]


"LEU" <LEU@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:89262094-EC8C-441F-888D-ADA468C82E4D@xxxxxxxxxxxxxxxx
When I am converting documents from WordPerfect to Word, I have a macro that
cleans up the new Word document. Some times when the macro runs it shows all
the changes being made and other times the screen goes blank while the
changes are being made. Is there a way to stop the screen from going blank?
When other people are running the macro they think the macro has locked up
and they try to stop it. Which then causes it to crash. Then they call me and
say it’s not working.

.

Relevant Pages

  • Re: Speed Issue
    ... I will look for a macro to remove all CFs and see if it speeds ... up a Solver worksheet that is slower in XL2007 than in XL2003 where it was ...
    (microsoft.public.excel.programming)
  • Re: tab named after a cell contents
    ... Your welcome, thanks for the feedback, and if you need it from a list you ... Paul B ... Always backup your data before trying something new ... To put in this macro, from your workbook right-click the workbook's icon ...
    (microsoft.public.excel)
  • Re: To Paul B. Again: Re: Making Everything Capital Letters In A Column: How ?
    ... Feedback on answers is always appreciated! ... If you want to use the macro, put it in as described, select all the data ... What do I set up as dummy cells or columns? ... change the macro security settings to get the macro to run. ...
    (microsoft.public.excel.newusers)
  • Re: Is it Possible to Stop a Macro?
    ... then turning calulation off can really speed things ... turning off the screen with Application.ScreenUpdating = False speeds ... It's a good idea for the macro to periodically put something on ... "Earl Kiosterud" wrote in message ...
    (microsoft.public.excel)
  • Re: Copy text in Word = OLE_LINKx Bookmark
    ... Thanks for your feedback: ... have a solution and only send the macro to those users who request it. ... > Hi Tito, ... > deletes all OLE bookmarks. ...
    (microsoft.public.word.pagelayout)