PRINT USING BUILT-IN PRINTER FONT ???

  • Thread starter Thread starter Naveen
  • Start date Start date
N

Naveen

How can I print my excel sheet using one of the built in
printer font ?

Is it possible with excel - or - do I need to use a word
processor or something ?
The font I am trying to use is Draft Condenced.But it is
not available in excel's Fonts list.Do I need to install
it ?
( I am using an Epson LQ300+ Dot matrix printer. )

Thanks,

Naveen
 
Naveen,

Epson will only print text files using its built-in fonts, so you could export your data to a .prn file prior to printing:
otherwise, you get Excel's formatting.

HTH,
Bernie
Excel MVP
 
Dear Sir,

Thanks a lot for the help.I am sorry for late reply
because I am using a dialup link and web access to the
newsgroup.

I have a problem now.
How to print the .prn file directly to the printer.
Printing after opening the file does not worked.
(It overides the printers built-in font with notepad's
font.)
I expect kind help from someone.

-Naveen

-----Original Message-----
Naveen,

Epson will only print text files using its built-in
Click to expand...
fonts, so you could export your data to a .prn file prior
to printing:
 
Dear Bernie,

Thank a lot for the help.
I could do it by the following DOS command.

C:\>PRINT myfile.prn

Is there a way to print using built in printer font with
Excel Or Access Directly ?.

Recently I have developed a salary system for my office
use.But accountant complains that it is printing salary
slips slower than the earliyer D-Base system.

Thanks & Regards,

Naveen




-----Original Message-----
Naveen,

If you don't remember DOS, then you're in for a little treat.

Start MSDOS (Start, Programs, MS-DOS PRompt) then
Click to expand...
navigate to the specific folder with the file you want to
print. Navigation can
be a bit tricky if your folder names are longer than 8 characters: using
Dir *.
will list the folders as DOS wants them to be named: for
Click to expand...
example, MyDocuments will be MyDocu~1
 
Dear Mr.Bernie,

How do I save the Excel file as '*.prn' using Excel's
VBA code ?
(Sorry for disterbing you.I Tried to find it. but not
succeeded.)

Tks & Rgds,
Naveen
 
Naveen,

If you want to edit the filename directly:
ActiveWorkbook.SaveAs FileName:="C:\Folder\Filename.prn", _
FileFormat:=xlTextPrinter, CreateBackup:=False

If you have a variable that holds the filename:
ActiveWorkbook.SaveAs FileName:="C:\Folder\" & VarFilename & ".prn", _
FileFormat:=xlTextPrinter, CreateBackup:=False

HTH,
Bernie
Excel MVP
 
Back
Top