I am trying to read a .txt file (using .Read within VBA):
and get the output formatted and into excel. The problem that I am having is trying to search the file stream for a particular sequence of characters i.e. a double carriage return ( chr(13) & chr(10) & chr(13) ). However, I have no idea how to do this, can anyone help me?![]()
filename = "h:\MS1\RccsDiagLog[RCCS_1]Rx26May07033507Rx.txt" Set fs = CreateObject("Scripting.FileSystemObject") Set f = fs.OpenTextFile(filename, 1, TristateFalse) data = f.read(10)
If this isn't possible I am willing to use another file reading method
Thanks,
Mortonic
Bookmarks