textline

Hi Team I have textfile with data in it as shown below , my task is to seperate below data in ColumnsSeperation Criteria is *---------So in Below situation Data should get populated in Column A,B,C.Thanks in advance. xxxxxxxx*--------------yyyyyyyy*--------------zzzzzzzz My attempted Code. with...

Hi All, I am having issue when doing a Line Input from a text file that has special characters in it. For example, the μ in the text below changes to μ Here is a snippet of my code: Do Until EOF(FF) Line Input #1 , TextLine TextFileArray(c) = TextLine c = c + 1...

Hi everyone, I need to extract the description text from a lot of html files. So I use this code to open and read the text from the html files. myFile = myPath & Filename Open myFile For Input As #1 Do Until EOF(1) Line Input #1 , textline posContent = InStr(1...

Hi, i had an issue in my job, i have to load an .txt file to excel but i can't get it to work help, the route it's fine and the msgBox displays the txt file, but the Open functions says err 53 not found... Sub OpenTextFile() Dim FilePath As String FilePath = Dir(Application.ThisWorkbook.Path &...