+ Reply to Thread
Results 1 to 5 of 5

Saving a sheet with code as a .prn, but the lines of code are too long?

  1. #1
    Registered User
    Join Date
    06-27-2012
    Location
    Bremerton, wa
    MS-Off Ver
    Excel 2003
    Posts
    2

    Saving a sheet with code as a .prn, but the lines of code are too long?

    So i have created a workbook with multiple sheets to input users information into a line of code on the last worksheet. Then i can save that last worksheet as formatted text (space delimited), or a .prn file, then creating it into a batch file.

    It works great with basic info, making a short line of code. But once i get all of the info in, the lines of code exceed the .prn limitation. Thus it breaks up the lines of code in the result. The other text files seem to put extra characters in, which can't really happen.

    The questions that this boils down to is; Is there a different way that i can export the information out of excel in a basic text file?

  2. #2
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,418

    Re: Saving a sheet with code as a .prn, but the lines of code are too long?

    Hello and welcome to the forum,

    Have you tried the comma-delimited file (.csv) approach? I apologize that I am not very familiar with what the fundamental differences between the .txt and .prn file types are.
    Please consider:

    Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
    Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.

  3. #3
    Registered User
    Join Date
    06-27-2012
    Location
    Bremerton, wa
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Saving a sheet with code as a .prn, but the lines of code are too long?

    The comma-delimited still adds commas. The work around i have just found is to save it as an HTML file, and then when you open that page, you can copy and paste it from there into a text file.

  4. #4
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,418

    Re: Saving a sheet with code as a .prn, but the lines of code are too long?

    You can always set up a save-as macro to save it as html then change the file name to .txt.

  5. #5
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,418

    Re: Saving a sheet with code as a .prn, but the lines of code are too long?

    I did a google search and it seems that this problem if frequent with several threads in different forums looking for workarounds. Also there is a possible solution for you provided by MS (http://support.microsoft.com/kb/249885).

    Hope this helps.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1