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

Last reviewed: September 12, 1996
Article ID: Q96451
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("HP LaserJet III on FILE:")
   =SEND.KEYS("myfile.prn")
   =PRINT()

where "HP LaserJet III on FILE:" is the printer name EXACTLY as it appears in the Default Printer dialog box in the Printers section of Windows Control Panel, and the "myfile.prn" 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).

REFERENCES

"Online Help," version 5.0 "User's Guide 2," version 4.0, pages 297-299, 535


KBCategory: kbprint
KBSubcategory:

Additional reference words: HOWTO Lotus 123 1-2-3



THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: September 12, 1996
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.