Creating a PRN file from Excel

D

davy_gravy

Hi

Thanks in advance for any help you can give me.

I'm working on a project right now that involves having a user enter
in a Journal Entry into an Excel spreadsheet, and then having the
spreadsheet process it and output a prn file. The prn file will then
be imported into SCT Banner. This is especially useful for large
Journal Entries, as it significantly cuts down on keying and the
associated time lost and errors created.

SCT Banner expects to get a file wherein each 'column' of data is left
aligned and comes with trailing spaces to fill up the column. My
problem is that Excel chops off all trailing spaces, without regard
for whether it is part of a column that has data or is a blank column
altogether. Does anyone know how to create a prn (because SCT Banner
does not seem to want to take anything except prn's) that doesn't chop
the extra spaces?

I have tried throwing in a character after the specified max range
(148), but that seems to throw Banner off as well.

Thanks,

Dave
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating PDF from Excel Using PrintToFile 6
Working Around 240 Character PRN Field Width Limit 1
How do I set up a macro to save an Excel worksheet as a .prn file? 2
create fixed length cells & rows in excel as space delimited .prn 1
Problem with Saving Excel File as PRN 4
convert an excel prn output file from dos to unix? 1
Line lenght limit while saving as a PRN file 4
format a right justified zero filled field to a prn file 4

Top