| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 24172 | 2002-09-05 01:39:00 | *.prn files - do they have a use | Mike S (1766) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 76553 | 2002-09-05 01:39:00 | I seek a way of sending a client (by e-mail) a copy of the printout, taken off an Excel worksheet. i.e. I want him to see the results but not the workings and I definitely don't want to send the *.xls file. I toyed with 'Print to file' and ended up with a *.prn file, but I don't seem to be able to do anything with it. What's the secret? Is prn the answer to my prayer? |
Mike S (1766) | ||
| 76554 | 2002-09-05 01:51:00 | Well, yes, but .csv is the industry standard to do what you want. (ctands for Comma Separated Values) and all workings are removed. Its actually a similar format to .prn, which is a printer definition file from DOS days. |
godfather (25) | ||
| 76555 | 2002-09-05 04:47:00 | I used to use PRN files a lot inthe old days where I took a floppy to Tech to get things printed (no emai then) I simply set up the Tech printer driver on my own computer, and then used the print to local file option, and then whack on a floppy. Sorry, I mean put it onto a floppy disk. Then at techh, go into DOS and type 'copy file.prn > prn' and this sent it to the printer. Oh wait, that might have been 'copy file.prn | prn'...oh, i forget... |
SoniKalien (792) | ||
| 76556 | 2002-09-05 05:35:00 | The problem is that "print to file" produces a file which is useful only on the particular printer it is made for. It's not a good idea to assume that someone who is "elsewhere" has a particular make and model of printer. Even if you ask them: many people have severe dificulty with technical questions like "what make and model of computer do you have". ;-) You tend to get answers like "the one on Bill's desk", or "a beige coloured one". By the way, copy /b file.prn prn: is the DOS command. (It usually needs the "/b" -- binary -- option. |
Graham L (2) | ||
| 76557 | 2002-09-05 05:42:00 | godfather's .csv idea will normally be an "export" option, won't it? It is likely to be a printable ASCII file, but it won't be pretty --- it's certainly not like a .PRN file. No columns, no formatting. It is really meant to be imported into a worksheet, which I suppose can then be printed, by Excel. Can you (I know nothing about Excel) create a "table" output, which would be importable to Word, which could then be used to print? Or just an ASCII output file ... ? |
Graham L (2) | ||
| 76558 | 2002-09-05 06:10:00 | The .csv is (by default) the standard transfer between various spreadsheets, they all seem to accept csv input. Excel has it as a standard file type selectable when saving. The csv file is very small in file size as well, for e-mailing. Everything in the way of formulas is lost. You can achieve the same thing and keep formatting by selecting the entire spreadsheet and file-copy-paste special-values. That leaves you with the same sheet (save it under a different name) with no formulas, just the end values. Its also a common way of interchanging data, as nobody likes giving too much away! |
godfather (25) | ||
| 76559 | 2002-09-05 06:28:00 | Could always just use a screen capture. | -=JM=- (16) | ||
| 76560 | 2002-09-05 08:47:00 | Instead of using the "Copy" command as mentioned above it is easier to just use the "Print filename.prn" command. | mikebartnz (21) | ||
| 76561 | 2002-09-05 09:46:00 | try printing to a free pdf printer (http://www.pdf995.com/) and emailing that. | wotz (335) | ||
| 76562 | 2002-09-05 12:45:00 | Just had a thoughut - why not export as HTML - then your client can view nicely iline in their mail, assuming they are not using some stodgy old text only email client | SoniKalien (792) | ||
| 1 2 3 | |||||