Results 1 to 4 of 4

How to View/Print ".prn" Files?

This is a discussion on How to View/Print ".prn" Files? within the Excel Questions forums, part of the Question Forums category; I just started playing around with the Print commands in Visual Basic. When I did a successful "Print to File" ...

  1. #1
    Board Regular SidBord's Avatar
    Join Date
    Aug 2004
    Location
    Morgan Hill, CA
    Posts
    346

    Default How to View/Print ".prn" Files?

    I just started playing around with the Print commands in Visual Basic.
    When I did a successful "Print to File" it created a file with an extension ".prn". How can I view/print this file? I can't seem to find a program that will open it.
    Dell Studio XPS 8000 with Windows 7 & Office 2007 and Norton Internet Security & Anti-Virus

    "The market will always do what it must
    ..to prove that the majority is wrong!"

    "Old Age and Treachery
    ....Will Always Win
    .Over Youth and Skill."

  2. #2
    Board Regular
    Join Date
    Dec 2002
    Location
    Tempe, Arizona
    Posts
    323

    Default Re: How to View/Print ".prn" Files?

    Quote Originally Posted by SidBord
    I just started playing around with the Print commands in Visual Basic.
    When I did a successful "Print to File" it created a file with an extension ".prn". How can I view/print this file? I can't seem to find a program that will open it.
    prn is a text file and can be opened by Excel by changing the file open window to look at "Files of Type" Text files.....

    You should also be able to print by opening Windows Exlporer and doing a right mouse click (menu key) on the prn filename and clicking Print on the resulting menu.
    Started building macros in Lotus 123, then Quattro Pro and now program in Excel VBA.

    Gaynard Nelson

    The race is not always to the swift
    But to those who keep on running

  3. #3
    Board Regular SidBord's Avatar
    Join Date
    Aug 2004
    Location
    Morgan Hill, CA
    Posts
    346

    Default Re: How to View/Print ".prn" Files?

    Thanx for the info. After I had made the post, it occurred to me that maybe I could use a print option on the dropdown list. But I didn't know about the text characteristic. I tried opening it with Note Pad and while it DID open it, it was virtually unreadable because of all the control stuff present.
    Dell Studio XPS 8000 with Windows 7 & Office 2007 and Norton Internet Security & Anti-Virus

    "The market will always do what it must
    ..to prove that the majority is wrong!"

    "Old Age and Treachery
    ....Will Always Win
    .Over Youth and Skill."

  4. #4
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454

    Default Re: How to View/Print ".prn" Files?

    Hi SidBord:

    In my experience, the Print To File command generates a binary file, and is to be used when you want to print the file to a specific printer later (because the specific printer may not be available at that time or location, or for whatever other reason).

    Then when you finally do want to print the file to that specific printer, you copy the file as a binary file to the printer as in the following command line when the file is being copied to the printer attached to LPT1 ...

    copy filename /b LPT1

    If I have misunderstood the question, my apologies!
    Regards!

    Yogi Anand, D.Eng, P.E.
    Energy Efficient Building Network LLC
    www.energyefficientbuild.com

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com