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

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

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

Keywords :
Version : 3.00 4.00 4.00a 5.00
Platform : WINDOWS
Issue type :