When printing out documents in relatively quick succession, things can get ” mixed up” if background printing is turned on. This is an option in Word. I have a macro which retrieves data from a database after a user enters an order number in an inputbox. After the macro retrieves the data. _:= ComObjMissing() oWord:= ComObjActive(“ation”) ; get MS Word object ut(Background:= true, _.
|Published (Last):||24 July 2015|
|PDF File Size:||2.1 Mb|
|ePub File Size:||20.48 Mb|
|Price:||Free* [*Free Regsitration Required]|
This article is written for users of the following Microsoft Word versions: If you are using a later version Word or laterthis tip may not work for you.
For a version of this tip written specifically for later versions of Word, click here: Printing the Active Document from a Macro. Macros really can make life easier. It is not uncommon to create macros that perform repetitive tasks, and thereby relieve us of the mundane tasks we might otherwise need to perform.
It is also not uncommon to need to print out the current document after doing some processing on it. If you find yourself with this need, you can simply let the macro take care of printing the current document. To add this capability to your macros, simply include a line like this:. The PrintOut method prints the specified document; in this case, the ActiveDocument object—the document currently selected—is printed.
In this particular usage, the Copies argument is used to specify how many copies of the document to print. When using the PrintOut method, there are quite a few different arguments you can use.
vba – ut issue – Stack Overflow
Rather than detail all of them, it is probably more useful to just look at some of the more common arguments you can use. If you would like to know how to use the macros described on this page or on any other page on the WordTips sitesI’ve prepared a special page that includes helpful information.
Click here to open that special page in a new browser tab. WordTips is your source for cost-effective Microsoft Word training. Microsoft Word is the most popular word processing software in the world. This tip applies to Microsoft Word 97, and You can find a version of this tip for the ribbon interface of Word Word and later here: With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author.
He is president of Sharon Parq Associatesa computer and publishing services company.
Learn more about Allen Insert a manual page break into the middle of a table, and you may find that subsequent pages of the table don’t always When you insert rows, columns, or cells in a worksheet, does the resulting Insert Options icon bother you? What happens when you copy information from one document and paste it into another? It is possible for what you paste to This complete guide shows both professionals and novices how to master VBA in order to customize the entire Office suite for their needs.
When working with macros, you can often speed up processing by turning off the updating of the screen. Best news is that Programming structures are an important tool used by any programmer. The VBA language used by Word’s macros includes The main body of your text is only one part of what makes up the entire document.
Printing the Active Document from a Macro
Documents can consist of other Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click “Subscribe.
Your e-mail address is not shared with anyone, ever. Maximum image size is 6Mpixels. Images larger than px wide or px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted. There are currently no comments for this tip. Be the first to leave your comment—just use the simple form above!
This site is for you! If you use a later version of Word, visit our WordTips site focusing on the ribbon interface.
View the most recent newsletter. To add this capability to your macros, simply include a line like this: The ranges are separated by commas and enclosed in quote marks, similar to how you specify page ranges in the Print dialog box. Used to specify the file name of the output file. Table Header Rows after a Manual Page Break Insert a manual page break into the middle of a table, and you may find that subsequent pages of the table don’t always Turning Off Insert Options When you insert rows, columns, or cells in a worksheet, does the resulting Insert Options icon bother you?
Cut and Paste Formatting What happens when you copy information from one document and paste it into another? Turning Off Screen Updating When working with macros, you can often speed up processing by turning off the updating of the screen.
Understanding the Select Case Structure Programming structures are an important tool used by any programmer.
Moving to the Start or End of the Real Document The main body of your text is only one part actuvedocument what makes up the entire document. Hide my email address.
How to print a range of pages from a word doc.
The page ranges to print. Normally False, but you can set it to True if you want output to go to a disk file instead of the printer. Only necessary if you set PrintToFile to True.