Microsoft KB Archive/138623

{|
 * width="100%"|

XL: "Cannot Print to LPT1" Running Lotus Print Macro

 * }

-

The information in this article applies to:


 * Microsoft Excel for Windows, versions 5.0, 5.0c

-

SYMPTOMS
In Microsoft Excel, if you run a Lotus 1-2-3 macro that performs a print command across a Novell network, you receive the following error messages

Macro error at cell:

where is the address of the macro's print statement followed by the error:

Error printing to LPT1

CAUSE
In order to print to a Novell Netware print queue, the LPT port must be redirected (captured) to the appropriate server and print queue. Lotus 1-2- 3 requires the printer port be captured. Microsoft Windows, by default, does not capture LPT ports. This capture must be done either at the MS-DOS level or through your Novell login script.

For additional information on this error under Microsoft Windows 95, please see the following article in the Microsoft Knowledge Base:

"Q152217 XL: Error Printing to LPT1 with 1-2-3 Print Macro in Windows"

WORKAROUND
To work around this problem, use either of the following methods.

Method 1
Use the Novell Capture command at the MS-DOS prompt before you enter Microsoft Windows to redirect or capture a printer port to a network server.

For example, the following capture statement redirects LPT1 to the server named SERVER1 and the printer queue named QUEUE1. It also turns off form-feed, banners, and disables time-outs.

  capture L=1 s=SERVER1 q=QUEUE1 nff nt nb ti=0 After you have restarted Windows, go to the Printers dialog box in Control Panel and connect your default printer to the port used in the capture statement.

Method 2: In Place of the Lotus 1-2-3 Print Macro, Use the XLCALL Function
Example:

The following Lotus macro prints the selected range:

  /ppr~agq Use the following in place of the above macro statement. The following runs a Microsoft Excel macro called Print_Macro to print the selected range.

  {XLCALL Print_Macro} Microsoft provides programming examples 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 article assumes that you are familiar with the programming language being demonstrated and the tools used to create and debug procedures. Microsoft support professionals can help explain the functionality of a particular procedure, but they will not modify these examples to provide added functionality or construct procedures to meet your specific needs. If you have limited programming experience, you may want to contact the Microsoft fee-based consulting line at (800) 936-5200. For more information about the support options available from Microsoft, please see the following page on the World Wide Web:

"http://www.microsoft.com/support/supportnet/overview/overview.asp" Microsoft Excel Visual Basic Macro Example:

  Sub Print_Macro Selection.PrintOut Copies:=1 End Sub

MORE INFORMATION
The Novell Netware Capture command redirects workstation printer output to a network print queue or file. The Capture command uses the following syntax

  capture L=x s=sss q=qqq nff nt nb ti=tt where:

L refers to the LPT port

x = LPT port number (1, 2, or 3)

s refers to the server

sss = server name

q refers to the server print queue

qqq = printer queue name

nff = no formfeed

nt = no tab

nb = no banner page

ti refers to the retry Timeouts

tt = time value (default is 10, 0 disables timeouts) Additional query words: 5.00c

Keywords : xlprint xlwin

Version : WINDOWS:5.0,5.0c

Platform : WINDOWS

Issue type :

Technology :