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
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
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.
Hi amberle,
Try replacingwith:Please Login or Register to view this content.
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.
That's what i need... Thank you so much Arkadi...
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)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks