Word – VBA – Print a Word Document. September 3, 2010 Daniel Pineault. VBA – Word – Open Word using Late Binding. VBA – Sending Faxes VBA. Search for: If you found this site helpful, consider giving a donation to offset the costs to keeping it running and thank you. Our Latest Poll. Copy the code in a Standard module of your workbook, if you just started with VBA see this page. Where do I paste the code that I find on the internet. Print visible, Hidden or all worksheets. If you want to print a whole workbook you can use ThisWorkbook.PrintOut Or ActiveWorkbook.PrintOut But this will not print hidden Worksheets.

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.

Lydia torrent paint it golden. Lydia Paint It Golden. Add to Custom List. Add to My Collection. AllMusic Rating. User Ratings (0). Lydia - Paint it Golden review: Get It Right. Lydia seemed like they were destined to be a one album wonder. 'Illuminate' was more than just an album it was a beautiful experience: the songs flowed together perfectly like you were reading a chapter book instead of listening to an album, the lyrics were heartfelt yet simple, the music was gorgeous yet aggressive, and every song on the album. Lydia: Paint it Golden By Collette Orquiz. Click to enlarge. Lydia's candid melodies paint a glittering picture of a dream-like sequence often seen in films. Paint It Golden Lydia. Released 2011. Paint It Golden Tracklist. Hailey Lyrics. Dragging Your Feet In The Mud Lyrics. Eat Your Heart Out Lyrics. Get It Right. Check out Paint It Golden by Lydia on Amazon Music. Stream ad-free or purchase CD's and MP3s now on Amazon.com.

To add this capability to your macros, simply include a line like this:ActiveDocument.PrintOut Copies:=1The 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. Rather than detail all of them, it is probably more useful to just look at some of the more common arguments you can use. ArgumentMeaningCopiesThe number of copies to print.PagesThe page ranges to print. The ranges are separated by commas and enclosed in quote marks, similar to how you specify page ranges in the Print dialog box.PrintToFileNormally False, but you can set it to True if you want output to go to a disk file instead of the printer.OutputFileNameOnly necessary if you set PrintToFile to True.

Used to specify the file name of the output file.

Document.PrintOut method (Word). 3 minutes to read.In this articlePrints all or part of the specified document. PrintOut ( Background, Append, Range, OutputFileName, From, To, Item, Copies, Pages, PageType, PrintToFile, Collate, FileName, ActivePrinterMacGX, ManualDuplexPrint, PrintZoomColumn, PrintZoomRow, PrintZoomPaperWidth, PrintZoomPaperHeight)expression Required. A variable that represents a object.

Parameters NameRequired/OptionalData typeDescriptionBackgroundOptionalVariantSet to True to have the macro continue while Microsoft Word prints the document.AppendOptionalVariantSet to True to append the specified document to the file name specified by the OutputFileName argument. False to overwrite the contents of OutputFileName.RangeOptionalVariantThe page range.

Can be any WdPrintOutRange constant.OutputFileNameOptionalVariantIf PrintToFile is True, this argument specifies the path and file name of the output file.FromOptionalVariantThe starting page number when Range is set to wdPrintFromTo.ToOptionalVariantThe ending page number when Range is set to wdPrintFromTo.ItemOptionalVariantThe item to be printed. Can be any WdPrintOutItem constant.CopiesOptionalVariantThe number of copies to be printed.PagesOptionalVariantThe page numbers and page ranges to be printed, separated by commas. For example, '2, 6-10' prints page 2 and pages 6 through 10.PageTypeOptionalVariantThe type of pages to be printed.

Can be any WdPrintOutPages constant.PrintToFileOptionalVariantTrue to send printer instructions to a file. Make sure to specify a file name with OutputFileName.CollateOptionalVariantWhen printing multiple copies of a document, True to print all pages of the document before printing the next copy.FileNameOptionalVariantThe path and file name of the document to be printed. If this argument is omitted, Word prints the active document. (Available only with the Application object.)ActivePrinterMacGXOptionalVariantThis argument is available only in Microsoft Office Macintosh Edition. For additional information about this argument, consult the language reference Help included with Microsoft Office Macintosh Edition.ManualDuplexPrintOptionalVariantTrue to print a two-sided document on a printer without a duplex printing kit.

If this argument is True, the PrintBackground and PrintReverse properties are ignored. Use the PrintOddPagesInAscendingOrder and PrintEvenPagesInAscendingOrder properties to control the output during manual duplex printing. This argument may not be available to you, depending on the language support (U.S.

English, for example) that you have selected or installed.PrintZoomColumnOptionalVariantThe number of pages you want Word to fit horizontally on one page. Can be 1, 2, 3, or 4. Use with the PrintZoomRow argument to print multiple pages on a single sheet.PrintZoomRowOptionalVariantThe number of pages you want Word to fit vertically on one page. Can be 1, 2, or 4. Use with the PrintZoomColumn argument to print multiple pages on a single sheet.PrintZoomPaperWidthOptionalVariantThe width to which you want Word to scale printed pages, in (20 = 1 point; 72 points = 1 inch).PrintZoomPaperHeightOptionalVariantThe height to which you want Word to scale printed pages, in (20 = 1 point; 72 points = 1 inch).ExampleThis example prints the current page of the active document. ActiveDocument.PrintOut Range:=wdPrintCurrentPageThis example prints all the documents in the current folder.

The Dir function is used to return all file names that have the file name extension '.doc'. Adoc = Dir('.DOC')Do While adoc 'Application.PrintOut FileName:=adocadoc = DirLoopThis example prints the first three pages of the document in the active window. ActiveDocument.ActiveWindow.PrintOut Range:=wdPrintFromTo, From:='1', To:='3'This example prints the comments in the active document. If ActiveDocument.Comments.Count = 1 ThenActiveDocument.PrintOut Item:=wdPrintCommentsEnd IfThis example prints the active document, fitting six pages on each sheet. ActiveDocument.PrintOut PrintZoomColumn:=3, PrintZoomRow:=2This example prints the active document at 75% of actual size.

ActiveDocument.PrintOut PrintZoomPaperWidth:=0.75. (8.5. 1440), PrintZoomPaperHeight:=0.75.

(11. 1440)See alsoSupport and feedbackHave questions or feedback about Office VBA or this documentation? Please see for guidance about the ways you can receive support and provide feedback.

Related Articles.