Print macros in Word 97

[John Marsden]

I'm writing some new macros for our users to print various combinations of
paper on Canon network printers, within Word 97, by recording the macro and
changing the trays within Page Setup. The macros work fine, in so much as
they print the right paper from the right trays, but in doing so the
document seems to refresh many times as the job is being sent to the
printer.

I would like to know how to turn off this 'refresh' on the screen, a problem
which didn't appear when I wrote similar macros in WordBasic in the earlier
Word 7. Also, looking in the macros in that version, there were much fewer
lines of code than there are in the new VB Basic, which I'm sure are not all
needed (e.g. Duplex=Off and Page Margin measurements). Could I safely trim
down this code as the other macros from Word 95 don't include these lines?

Appreciate any help you could offer.

Many Thanks,

John

 

[Charles Kenyon]

You can safely trim the code. Don't know about the flicker/refresh but you
can turn screen refresh off at the beginning of your macro and back on at
the end.
--
Charles Kenyon

Word New User FAQ & Web Directory:
<URL: http://addbalance.com/word/index.htm>

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide)
<URL: http://addbalance.com/usersguide/index.htm>

See also the MVP FAQ: <URL: http://www.mvps.org/word/> which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

 

[John Marsden]

Thanks for the reply Charles. I will try your suggestions out.

For reference, I've found out that the command for turning refresh on and
off is something like "Application.ScreenUpdating = False or =True'. But
this may be unnecessary if I can cut back the code as you suggest.

John Marsden