+ Reply to Thread
Results 1 to 5 of 5

Removing extra line from generated file

  1. #1
    Forum Contributor
    Join Date
    04-22-2016
    Location
    Philippines
    MS-Off Ver
    2007, 2013, 2016, Office365
    Posts
    118

    Post Removing extra line from generated file

    Good day everyone....

    Please help me to remove the extra blank or line from generated file created.
    Generated file should be no extra line without data (or blinking cursor should be at last character generated)

    Thanks,

    See attached file FYI
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    04-22-2016
    Location
    Philippines
    MS-Off Ver
    2007, 2013, 2016, Office365
    Posts
    118

    Re: Removing extra line from generated file

    I am generating data from spreadsheet into similar(txt file) provided and every time I open it to notepad, there is blank line after the last data which I need it to be at the last value/character.
    So I need to re-open the generated file to notepad, hit ctrl+end then hit backspace from last blank line just to remove it and then re-save it.
    I am looking for any vba code to do this automatically when generating it or by modifying the existing text file without the last blank line.

  3. #3
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 2016
    Posts
    4,907

    Re: Removing extra line from generated file

    Hi amberle,

    Try replacing
    Please Login or Register  to view this content.
    with:

    Please Login or Register  to view this content.
    Please help by:

    Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
    Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know

    There are 10 kinds of people in this world... those who understand binary, and those who don't.

  4. #4
    Forum Contributor
    Join Date
    04-22-2016
    Location
    Philippines
    MS-Off Ver
    2007, 2013, 2016, Office365
    Posts
    118

    Re: Removing extra line from generated file

    That's what i need... Thank you so much Arkadi...

  5. #5
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 2016
    Posts
    4,907

    Re: Removing extra line from generated file

    My pleasure

    Please remember to mark the thread as solved if you are satisfied that your issue is fixed? Thanks in advance! (And thanks for the rep)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Removing Extra Empty Columns From Generated PDF?
    By bdpna in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-13-2018, 04:16 PM
  2. [SOLVED] Removing blank lines from generated results
    By MagicMan in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-23-2017, 03:02 PM
  3. [SOLVED] Removing line breaks from .cvs file BEFORE importing
    By banaanas in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-18-2015, 06:40 AM
  4. [SOLVED] Removing Extra Whitespace
    By sperry2565 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-03-2013, 10:00 AM
  5. Search for a line in all Modules in a workbook and add extra line below
    By sans in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-20-2013, 03:17 PM
  6. Removing extra sheets.
    By pawnraider in forum Excel General
    Replies: 6
    Last Post: 11-29-2012, 11:46 AM
  7. [SOLVED] How do I add an extra line to a line-column chart?
    By moose in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-23-2006, 01:35 PM

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