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?Please Login or Register to view this content.
If this isn't possible I am willing to use another file reading method
Thanks,
Mortonic
Bookmarks