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: Akicage Tesho
Country: Switzerland
Language: English (Spanish)
Genre: Politics
Published (Last): 7 April 2014
Pages: 166
PDF File Size: 8.18 Mb
ePub File Size: 4.87 Mb
ISBN: 636-7-52996-832-6
Downloads: 49886
Price: Free* [*Free Regsitration Required]
Uploader: Dokora

Desktop Specs Laptop Specs. String variable length Range Billion characters! Several functions may not work.

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

Username Changing provided by Username Change v1. Best Answer Pulover16 April – Wow, I have no words, thanks everyone, honestly, for the quick answers and for all the help. By continuing to use our website, you agree to the use of such cookies. Post as a guest Name. When you insert rows, columns, or cells in a worksheet, does the resulting Insert Options icon bother you?

Printing the Active Document from a Macro

Can be any WdPrintOutPages constant. This is an option in Word:.

If this argument is omitted, Word prints the active document. Macros really can make life easier. Students Click Here Join Us!


I am able to print about 30 pages, but if I eliminate the section number if it’s a one-section documentI can nearly double the number of pages by using 1,5,7,12, etc.

Enter your address and click “Subscribe. Learn more about Allen I can’t xctivedocument now but one of them printed the document, problem was it printed out the whole document, not the specified range. Referring back to ActiveDocument each time is less efficient VBA has to figure out which it is, every time.

If my boss knew of ‘ahk’ he would probably fire the whole office LOL. Hide my email address.

MS Word: ut – VBA Visual Basic for Applications (Microsoft) – Tek-Tips

A String can include letters, numbers, spaces, and punctuation. Posting Guidelines Promoting, selling, recruiting, coursework and thesis posting is forbidden.

The Tek-Tips staff will check this out and take appropriate action. Be the first activedocumetn leave your comment—just use the simple form above! Copies Optional Variant The number of copies to be printed. Remember activedockment This is not recommended for shared computers. PrintOutI notice an abnormal printing behaviour. Commenting privileges may be curtailed if inappropriate images are posted.

Document.PrintOut method (Word)

Printtout data type Variant data type A special data type that can contain numeric, string, or date data as well as the special values Empty and Null. I’ve deleted those lines. You can find a version of this tip for the ribbon interface of Word Word and later here: Make sure to specify a file name with OutputFileName.


Cut and Paste Formatting What happens when you copy information from one document and paste it into another? To add this capability to your macros, simply include a line like this: I already did that, I tried these combinations: Range Optional Variant The page range. This argument is available only in Microsoft Office Macintosh Edition. Click here for more information on our Cookie Policy and Privacy Policy.

Application” ; get MS Word object oWord. Only necessary if you set PrintToFile to True.

The Variant data type has a numeric storage size of 16 bytes and can contain data activedocumen to the range of a Decimal, or a character storage size of 22 bytes plus string lengthand can store any character text. Stack Overflow works best with JavaScript enabled. Any help would be most appreciated. Printout issue Ask Question.

The above FAQ links open in a new window. Sign In Create Account. Hi guys, I really need help with this script.