Added text to first line of text file using notepad

I found the following VBA code below which append text to an existing text file using notepad at the end of the file.

Please Login or Register  to view this content.

I have been trying to add text to a specific line but I have not been successful. The solution that I want would be to open an existing text file using notepad, add a blank line at the top of the text file. So original line #1 would move to line #2 and line #1 would be blank. See examples below. Thank you in advance for your time.


Original file:

Line 1 | This is line #1
Line 2 | This is line #2


New file after macro:

Line 1 |
Line 2 | This is line #1
Line 3 | This is line #2

Originally Posted by CK76

Please Login or Register  to view this content.

I would like to suggest you use vbNewLine instead of vbCrLf when introducing a new line in text that will be written to a disk. On a PC, vbNewLine equates to vbCrLf whereas on a Mac, which does not use vbCrLf for its new lines as far as I know, it will automatically use whatever Macs use for new lines (Macs used to use vbCr before switching to a Linux underpinning... true Linux uses vbLf but I don't know if that was adopted by Macs or not). Anyway, the point is vbNewLine automatically equates to whatever new line the system running the code uses when writing to a disk.

Thank you all for your response. CK76 solution work on my test file which is just 2 lines long. Our longest file we need to work with is 2,800,000 lines long so I suspect it is a memory issue? I got the following VBA error message:

Run-time error 62.
Input past end file


Any other code that would be friendly to very large text files or not have to store text file content to memory before writing new blank 1st line? Could use keyboard short-cut from vba that would be recognize by notepad like:
1) CTRL+Home to get to top of file
2) Press enter to have 1st blank line
3) Control+S to save file and
4) Alt+F4 to close file

No the best solution but may get around the memory issue? Thank you!

Thank you CK76 for all the other possible solution. I was able to make it work with send key but again not on my big file. I'll mark as solved as I have a few solutions I can look at and it may just be my file a just too big. Thanks again!