End of file marker from Text File - Delete?

4

43fan

How can I get rid of an EOF marker that's in an imported text file? The
text file is created from within a FPD2.6 program, which automatically puts
the EOF marker/code there. When Excel opens it, of course it just shows up
like a little box. This won't always be in the same row, although will
always be in the same column.

Is there a way to eliminate this using VBA? I open the text file, then copy
the data into another spreadsheet. I have no way of knowing the number of
"records" that will be copied, so I just copy the entire sheet.

Thanks!
Shawn
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Reading Text file into an array 5
Hanging Indent/Left indent marker 3
Importing text file without end-of-line delimiter? 8
Removing an EOF marker in a text file for importation 12
Find the Length of a Text File 4
Excel Send Lotus Notes Mails With VBA Macro Excel 0
Selactively read text file 2
Copying Text from a file into Excel w/ Macro 6

Top