Microsoft KB Archive/136085

{|
 * width="100%"|

XL5NT: Can't Print Multiple Copies of a Document in Windows 95

 * }

-

The information in this article applies to:


 * Microsoft Excel for Windows NT, version 5.0
 * Microsoft Windows 95

-

SYMPTOMS
In Microsoft Windows 95, when you attempt to print multiple copies of a document in Microsoft Excel version 5.0 for Windows NT, only one copy of the document is printed.

CAUSE
This problem occurs because Microsoft Excel for Windows NT does not correctly use the Microsoft Windows 95 API that controls the number of copies that are printed during each print job.

WORKAROUND
Method 1: To work around this problem, use the following Visual Basic for applications code to print multiple copies. Microsoft provides examples of Visual Basic for applications procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. This Visual Basic procedure is provided 'as is' and Microsoft does not guarantee that it can be used in all situations. Microsoft does not support modifications of this procedure to suit customer requirements for a particular purpose.

         'A procedure to print multiple copies Sub Example On Error GoTo PrintEmbeddedChart ' Dimension variables Dim Ncopies As Integer, Counter As Integer Ncopies = _ Application.InputBox _ ("Please enter number of copies to print: ", _              "Print Multiple Copies", 1,, , , , 1)

For Counter = 1 To Ncopies ActiveWindow.SelectedSheets.PrintOut Copies:=1 Next Exit Sub

'Error handler to print embedded charts PrintEmbeddedChart: For Counter = 1 To Ncopies ActiveChart.PrintOut Copies:=1 Next End Sub

Method 2: To print multiple copies of a Microsoft Excel document from Microsoft Windows 95, use Microsoft Excel for Windows 95, version 7.0.

MORE INFORMATION
There are only two API calls to print more than one copy from the printer in Microsoft Windows 95. An application written specifically to run under Microsoft Windows NT doesn't use either of these API calls. This functionality does work if you are using Microsoft Windows NT.

Additional query words: xlnt

Keywords :

Version : 5.00

Platform : WINDOWS

Issue type :

Technology : kbvcSearch