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, _.

Author: Fautaxe Akirisar
Country: Bahrain
Language: English (Spanish)
Genre: Personal Growth
Published (Last): 27 June 2011
Pages: 413
PDF File Size: 12.84 Mb
ePub File Size: 11.33 Mb
ISBN: 556-9-81254-606-7
Downloads: 22525
Price: Free* [*Free Regsitration Required]
Uploader: Nikot

The ranges are separated by commas and enclosed in quote marks, similar to how you specify page ranges in the Print dialog box. The page ranges to print. prlntout

I would like to be able to print out different ranges, for example: Normally False, but you can set it to True if you want output to go to a disk file instead of the printer.

Copies Optional Variant The number of copies to be printed. Range Optional Variant The page range. With more than 50 non-fiction acticedocument and numerous magazine articles to his credit, Allen Wyatt is an priintout recognized author.

String Range Variant Range any number up to double or any string.

vba – ut issue – Stack Overflow

Understanding the Select Case Structure Programming structures are an important tool used by any programmer. What’s the easiest way to become a member and start posting?


The target document is just a placeholder where we are placing info for printing about each annexure in header area at runtime and sending printout command to printer. I am gonna give it a try and I am sure the changes you have made will make it more efficient code for my purposes. The Dir function is used to return all file names that have the file name extension “.

Item Optional Variant The item to be printed. Sign up using Facebook. I need this to print the document as soon as it runs the PrintOut command.

Printing the Active Document from a Macro

PrintOut” but with Word docs. Afterward, the macro calls the command to print the document: Apr 03 Microsoft Word is the most popular word processing software in the world.

Pages Optional Variant The page numbers and page ranges to be printed, separated by commas. When you insert rows, columns, or cells in a worksheet, does the resulting Insert Options icon bother you? Our new feedback system is built on GitHub Issues.

Sign up or log in Sign up using Google. By clicking “Post Your Answer”, you acknowledge that you have read our updated terms of serviceprivacy policy and cookie policyand that your continued use of the website is subject to these policies.


You may also leave feedback directly on GitHub. Collate Optional Variant When printing multiple copies of a document, True to print all pages of the document before printing the next copy. I have two word documents, source and target.

Does anybody know activedocumentt it doesn’t work when I actiedocument variables? Only necessary if you set PrintToFile to True. Is there any way to find out the number of pages of a word document?

Printing the Active Document from a Macro (Microsoft Word)

This argument may not be available to you, depending on the language support U. It is possible for what you paste to Thanks, but I’m asking about the maximum length of the Pages parameter of the Printout method of ActiveDocument. A variable that represents a ‘ Document ‘ object. I just checked and noticed that the “Print in background” option was checked. Programming structures are an important tool used by any programmer.