How to print directly to Excel?
 

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?

How to print directly to Excel?
 

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.

"Excel Curious" wrote:

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?

How to print directly to Excel?
 

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
"Excel Curious" wrote in message
...
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?

How to print directly to Excel?
 

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

On Nov 29, 11:43 pm, Excel Curious
wrote:
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?

How to print directly to Excel?
 

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.
:-(
"Conan Kelly" wrote:

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
"Excel Curious" wrote in message
...
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?

How to print directly to Excel?
 

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

Excel Curious wrote:
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.
:-(
"Conan Kelly" wrote:


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
"Excel Curious" wrote in message
...

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?