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: Kagagrel Gardasar
Country: South Sudan
Language: English (Spanish)
Genre: Environment
Published (Last): 24 May 2016
Pages: 286
PDF File Size: 13.51 Mb
ePub File Size: 12.86 Mb
ISBN: 270-5-24912-151-4
Downloads: 8407
Price: Free* [*Free Regsitration Required]
Uploader: Daran

Document Dim tDoc as Word. This example prints all the documents in the current folder. Ditto for repeatedly requesting Tables 3.

By joining you are opting in to receive e-mail. Can be 1, 2, or 4. Normally False, but you can set it to True if you want output to go to a disk file instead of the printer.

My business begins with 6th row that shows Annexure A. I just checked and noticed that the “Print in background” option was pgintout. Everything works fine as long as I test values in Debug. Only necessary if you set PrintToFile to True.

Using ut | Windows Secrets Lounge

Activedocumenr I use this: Sign in to give feedback. When you insert rows, columns, or cells in a worksheet, does the resulting Insert Options icon bother you? Post Your Answer Discard By clicking “Post Your Answer”, activedocumejt 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.


This site is for you! 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. Thank you Blackholyman, you saved my day again. PrintOutI notice an abnormal printing behaviour. The String data type can store pringout strings ranging in length from 0 to approximately 63K characters and dynamic strings ranging in length from 0 to approximately 2 billion characters.

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. Any feedback from you guys would be much appreciated. Turning Off Screen Updating When working with macros, you can often speed pirntout processing by turning off the updating of the screen. There are currently no comments for this tip.

Printing the Active Document from a Macro

Put Option Explicit at the top of your code modules. This article is written for users of the following Microsoft Word versions: Click here to open that special page in a new browser tab. Note that I’m not testing, just writing from the top of my head, so I may make a typo or two I hope I’ve kept “everything straight”!

And I’m starting to understand how this COM functions work, it’s a long way ahead but for every little thing I learn I imagine a thousand ways of using them. Results 1 to 4 of 4. Is there something in the VB environment that hangs the print queue? After the macro retrieves the data, it puts the info in some bookmarked places in the active document in MS Word. String Range Variant Range any number up to double or any string.


The number of pages you want Word to fit vertically on one page. Best Answer Pulover16 April – Reasons such acyivedocument off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

In this particular usage, the Copies argument is used to specify how many copies of the document to print. I can’t remember now but one of them printed the document, problem was it printed out the whole document, not activedocumenh specified range. Macros really can make life easier. Page 1 of 2 1 2 Next.

Enter your address and click “Subscribe.

Sign up using Email and Password. To add this capability to your macros, simply include a line like this:. For additional information about this argument, consult the language reference Help included with Microsoft Office Macintosh Edition.

How do I configure the display of members’ images and signatures? Activexocument Disabled Detected You currently have javascript disabled.

True to print a two-sided document on a printer without a duplex printing kit. Afterward, the macro calls the command to print the document: For a version of this tip written specifically for later versions of Word, click here: This functions just as I want it to, but the Pages option seems to have a limit. For example, “2, ” prints page 2 and pages 6 through Sign up using Facebook. I also tried using wdPrintRangeOfPages with the same result.