HOWTO: Printing a Range of Pages in Word Using OLE Automation

• Microsoft Word for Windows 95, versions 7.0, 7.0a
• Microsoft Word 97 for Windows
• Microsoft Visual Studio versions 97, 97sp2
• Microsoft Visual FoxPro for Windows, versions 3.0b, 5.0a

SUMMARY

Printing either a range or selection of pages in a Word for Windows document from Visual FoxPro for Windows using OLE automation requires additional parameters for the PrintOut method of Word for Windows 97 or the FilePrint command in Word for Windows 95.

All the parameters passed to Word in an OLE automation statement are positional. For example, the Range parameter is the third argument out of 15 in the parameter list for the Printout method. Therefore, arguments 1 and 2 must have the appropriate value for the argument and cannot be left out. However, any arguments past the last argument with a value do not need to be included in the command. For example, if no other parameters require a value after the Range is set, then Range could be the last argument passed to the PrintOut method.

MORE INFORMATION

The code samples in this article are written to run exclusively with a particular version of Word. The examples for Word for Windows 95 were written to work with both Visual FoxPro for Windows versions 3.0b and 5.0a. The Word 97 example work only with Visual FoxPro for Windows version 5.0a with Service Pack 2 installed. If the code is used with any other version of Word or Visual FoxPro for Windows, the following OLE error may occur:

   OLE error code 0x80020005: Type Mismatch.

   0 Prints the entire document
   1 Prints the selection
   2 Prints the current page
   3 Prints the range of pages specified by the From and To parameters
   4 Prints the range of pages specified by Pages parameter

   PrintOut(Background, Append, Range, OutputFileName, From, To,
   Item, Copies, Pages, PageType, PrintToFile, Collate, FileName,
   ActivePrinterMacGX, ManualDuplexPrint)

   FilePrint(.Background, .AppendPrFile, .Range, .PrToFileName, .From,
   .To, .Type, .NumCopies, .Pages, .Order, .PrintToFile, .Collate,
   .FileName, .OutputPrinter)

Printing Contiguous Range of pages

There are two ways to print a contiguous range of pages using the Range parameter. Both methods depend on the value of Range. For instance, if the Range is set to 3, then set the From and To parameters. If the Range is 4, use the Pages parameter. Both methods are discussed below. In each code example, the FilePrint and PrintOut commands are shown using both variables and the explicit values for the arguments. This provides a better representation of the positions these arguments will take in the statement. The command using variables is commented out.

Method 1: Range Argument Set to 3

With the Range set to 3, the From and To parameters need to set for both the PrintOut method in Word 97 and FilePrint command in Word 95.

For example, to print pages 4 through 8 of Testdoc.doc use the following Code.

NOTE: This works with Word 95 and Visual FoxPro for Windows versions 3.0 and 5.0.

     range = "3"
     from = "4"
     to = "8"
     oword = CreateObject("Word.Basic")
     WITH oword
      .FileOpen("C:\winword\testdoc.doc")   && Enter appropriate path.

      * FilePrint statement using variables.
      *.FilePrint(0,"0","",0,range,"",from,to)

      * FilePrint using explicit values
      .FilePrint(0,"0","",0,"3","","4","8")
      .FileClose(2)
     ENDWITH
     oword=""

     range = "3"
     from = "4"
     to = "8"
     oword = CreateObject("Word.Application")
     WITH oword
      .Documents.Open("C:\winword\testdoc.doc")  && Enter appropriate path.

      * PrintOut statement using variables
      *.ActiveDocument.PrintOut(0,0,range,"",from,to)

      * PrintOut using explicit values
      .ActiveDocument.PrintOut(0,0,"3","","4","8")
      .Quit
     ENDWITH

Assign 4 to the Range argument, then assign the pages to be printed to the Pages argument. To print pages 4 through 8, the Pages argument would be "4- 8."

NOTE: This works with Word 95 and Visual FoxPro for Windows versions 3.0 and 5.0:

     range = "4"
     pages = "4-8"
     oword = CreateObject("Word.Basic")
     WITH oword
      .FileOpen("C:\winword\testdoc.doc")   && Enter appropriate path.

      * FilePrint statement using variables.
      *.FilePrint(0,"0","",0,range,"","","",0,1,pages)

      * FilePrint using explicit values
      .FilePrint(0,"0","",0,"4","","","",0,1,"4-8")
      .FileClose(2)
     ENDWITH
     oword=""

     range = "4"
     pages = "4-8"
     oword = CreateObject("Word.Application")
     WITH oword
      .Documents.Open("C:\winword\testdoc.doc")  && Enter appropriate path.

      * PrintOut statement using variables
      *.ActiveDocument.PrintOut(0,0,range,"","","",0,1,pages)

      * PrintOut using explicit values
      .ActiveDocument.PrintOut(0,0,"4","","6","8",0,1,"4-8")
      .Quit
     ENDWITH

To print non-contiguous pages, set the Range parameter to 4 and the Pages parameter to the pages to print. For example, to print page 2 and then pages 6 through 9, the Pages argument would be "2,6-9." The Pages parameter is set the same for both Word 95 and Word 97.

NOTE: This works in Word 95 and Visual FoxPro for Windows versions 3.0 and 5.0:

     range = "4"
     pages = "2,6-9"
     oword = CreateObject("Word.Basic")
     WITH oword
      .FileOpen("C:\winword\testdoc.doc")   && Enter appropriate path.

      * FilePrint statement using variables.
      *.FilePrint(0,"0","",0,range,"","","",0,1,pages)

      * FilePrint using explicit values
      .FilePrint(0,"0","",0,"4","","","",0,1,"2,6-9")
      .FileClose(2)
     ENDWITH
     oword=""

     range = "4"
     pages = "2,6-9"
     oword = CreateObject("Word.Application")
     WITH oword
      .Documents.Open("C:\winword\testdoc.doc")  && Enter appropriate path.

      * PrintOut statement using variables
      *.ActiveDocument.PrintOut(0,0,range,"","","",0,1,pages)

      * PrintOut using explicit values
      .ActiveDocument.PrintOut(0,0,"4","","","",0,1,"2,6-9")
      .Quit
      ENDWITH

REFERENCES

Microsoft Word Visual Basic Help

Keywords          : FxinteropOle FxprgGeneral vfoxwin kbcode
Version           : WINDOWS:3.0b,5.0a,7.0,7.0a,97; WINNT:97,97sp2
Platform          : WINDOWS winnt
Issue type        : kbhowto