How to print directly to Excel?

[Excel Curious]

I have a program that automatically prints a report to my default printer
without opening a print window first. Is there a way to add Excel to my list
of available printers to that I can choose it as my default printer?

 

[JLatham]

Short answer: no. A printer requires software known as a printer driver, and
their ain't no such an-i-mule for Excel.

The program may have the ability to Save As in either .xls file format or
..csv file format. If it can do that, then it's much the same as printing to
Excel. Look for Save As under the File menu option of your program, that's
the normal location for it if it is available.

 

[Conan Kelly]

XL Curious,

Does that program have a Print Dialog also (dialog box opens to choose
printer & settings......"File">"Print..." or [Ctrl] + P)?

If so, look through the Print Dialog to see if it will allow you to "Print
to File". Hopefully it will print in a format that is easily parsed by XL.

HTH,

Conan

 

[Pete_UK]

If your program has a Print dialogue (to change printers, orientation
etc), then you will often have an option of Print to File - you need
to specify a filename (often with a .prn extension) and then a text
file is created which can be brought into Excel by doing File | Open,
whereupon the Text Import Wizard will start and guide you through the
process. Similar to importing a .txt file, in that there will be no
formatting in the .prn file.

Hope this helps.

Pete

 

[Excel Curious]

My program is much like a DOS program so there are no menus. To print I
simply type a "P" in the transmit field and hit enter and it sends the
request to my default printer. So there are no options to choose a printer or
choose any print settings at all. I suppose I'll have to contact my IT
department with this, but there always too busy for questions of this sort.
:-(

XL Curious,

Does that program have a Print Dialog also (dialog box opens to choose
printer & settings......"File">"Print..." or [Ctrl] + P)?

If so, look through the Print Dialog to see if it will allow you to "Print
to File". Hopefully it will print in a format that is easily parsed by XL.

HTH,

Conan

I have a program that automatically prints a report to my default printer
without opening a print window first. Is there a way to add Excel to my
list
of available printers to that I can choose it as my default printer?

 

[Bob I]

What is it that you expect Excel to do with it? Excel isn't a print engine.

My program is much like a DOS program so there are no menus. To print I
simply type a "P" in the transmit field and hit enter and it sends the
request to my default printer. So there are no options to choose a printer or
choose any print settings at all. I suppose I'll have to contact my IT
department with this, but there always too busy for questions of this sort.
:-(
:

XL Curious,

Does that program have a Print Dialog also (dialog box opens to choose
printer & settings......"File">"Print..." or [Ctrl] + P)?

If so, look through the Print Dialog to see if it will allow you to "Print
to File". Hopefully it will print in a format that is easily parsed by XL.

HTH,

Conan

I have a program that automatically prints a report to my default printer
without opening a print window first. Is there a way to add Excel to my
list
of available printers to that I can choose it as my default printer?