Print to file problem

  • Thread starter Thread starter Dave May
  • Start date Start date
D

Dave May

Original post was "Spreadsheet saved to a file"

Problem is how to print a file that was created by
using "Print To File" from an EXCEL spreadsheet.

The answer posted in response does not solve the problem.
I cannot open the print file in EXCEL or any other
meaningful way. I CAN get the 'text' of the file into
excel or a word processor, but printing from there does
not result in a normal EXCEL spreadsheet output. The file
created has no extension. What should the extension (if
any) be? Any ideas on how to use this file to print out
the original spreadsheet?
Thanks in advance.
 
I didn't see the earlier post so apologies if I'm repeating the answer
posted there.

When you select "print to a file" you get all the formatting/printer
controls codes in the file that would have gone to the printer in a normal
print. So the result is meaningless to any program that doesn't speak
"printerese".

One possible way to address this is to "copy" the file to the printer from a
command window. To try this open a DOS/Command window and enter a command
like this at the C: prompt and press Enter:

print /d:\\pma0010f38\EOM_HP_8150N_2-1123_Q output

This worked for me but you have to substitute the path/name of your printer
(after the /d:) and the name of your print file ("output" for me) with a
space between each.

If there's a bettor way to do this (and there probably is) it didn't occur
to me.
 
Back
Top