I am trying to select and copy text from a text file that I am opening in Notepad and paste the copied data into Excel. I have to open the txt file in Notepad b/c the file is too large to open in Excel. I need to copy all lines from 161,237 to EOF.

I am using this code to open the txt file:

Shell "Notepad.exe" & " " & "n:\myfiles\2006 Work\NEMS FY06\Fuel Cell Work\RDGENOUT.txt", _
vbNormalFocus

I can't figure out how to skip to line 161,237 in this file and select all lines to the EOF and copy these lines.

hi there...

i dont follow you.. why are you opening the file in notepad and not just open in it vb??

HTH

Gonzalo

I am using VB in Excel to open the txt file in notepad using the code:

Shell "Notepad.exe" & " " & "n:\myfiles\2006 Work\NEMS FY06\Fuel Cell Work\RDGENOUT.txt", _
vbNormalFocus

I am unable to use VB code such as openText Filename b/c the txt file has more lines than Excel will handle.

so, you are using VBA... can you just use the filesystemobject to open the file as a textstream?? that will do the things easy for you.. for that you will have to add a reference to microsoft scripting object..

HTH

Gonzalo

How would I then go to the necessary lines and select/copy them without select/copying the entire file?

well now you have to research a little.. the textstream object will open the file like a stream of chars. You can read lines in the file and then start copying when you reach the position you need...

i dont have an example here, but look in the msdn for it...

HTH

Gonzalo