There are several ways to do this. 1 method is to use Workbooks.OpenText.
You can use macro recorder to get basic syntax.
Ex:
Workbooks.OpenText Filename:="C:\SomeFolder\Test Input.txt", _ Origin:=xlWindows, StartRow:=1, DataType:=xlDelimited, TextQualifier:= _ xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=False, Semicolon:=False, _ Comma:=False, Space:=False, Other:=True, OtherChar:="-", FieldInfo:= _ Array(Array(1, 1), Array(2, 1), Array(3, 1), Array(4, 1)), TrailingMinusNumbers:= _ True
Last edited by CK76; 01-08-2019 at 12:00 PM.
?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
― Robert A. Heinlein
I don't know how I could use the recorder for this? When I tried copy-paste method, it only recorded "paste".
I have an interesting issue with too though.
1) It opens a new file (but that can easily be fixed). I'm guessing it's in the name... OpenText
2) More weird. If I have a line where the first message starts with capital F, it removes the F and moves the message to next column.e.g. 07/02/2017, 15:46 - John Doe: Fordi det er så mange fejl når jeg skriver på dansk becomes split intoI have tried looking into that, but I cannot find a good reason for this behaviour?
07/02/2017, 15:46 - John Doe: ordi det er så mange fejl når jeg skriver på dansk
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks