Microsoft KB Archive/96451

{|
 * width="100%"|

Excel Err Msg: Not Translated: Print to File Not Available

 * }

-

The information in this article applies to:


 * Microsoft Excel for Windows, versions 3.0, 4.0, 4.0a, 5.0

-

SUMMARY
The Microsoft Excel Macro Translation Assistant may not correctly translate some third-party macros that print to a file. When this incorrect translation occurs, you will receive the following error message:

Not translated: Print to file not available

Workaround
To use the translated macro to print to a file, edit it so that it includes the Microsoft Excel macro functions PRINTER.SETUP, SEND.KEYS, and PRINT, as in the following macro example:

  =PRINTER.SETUP(&quot;HP LaserJet III on FILE:&quot;) =SEND.KEYS(&quot;myfile.prn&quot;) =PRINT where &quot;HP LaserJet III on FILE:&quot; is the printer name EXACTLY as it appears in the Default Printer dialog box in the Printers section of Windows Control Panel, and the &quot;myfile.prn&quot; argument in the SEND.KEYS function is the output filename to be printed to.

MORE INFORMATION
Microsoft Excel for Windows requires that the printer be connected to the port name as it appears in the Windows Control Panel (in the above example this port name is FILE).