.prn Files to Excel

  • Thread starter Thread starter Ray
  • Start date Start date
R

Ray

Hello,

I work in a system that displays data in spreadsheet
format (display only, not editable). The system does not
allow you to copy to the clipboard.

I would like to put this data into excel to manipulate.
The only way I can see is to print to a file (*.prn). Is
there a way to open or use this file format in excel
along the lines of a CSV or TXT file. If I try and open
it with Excel the page comes up with squares and symbols
everywhere.

Any help would be appreciated.

Thanks

Ray
 
Ray,

As far as I know, you can't open a prn file in Excel and get any
meaningful data.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
How about changing your printer to a Generic Text printer. Then use your
application to print to a file based on that Printer.

In Win98, I could even install that "generic text" printer to print directly to
a file (not LPT1).
 
Back
Top