textline

  1. M

    vba Read Text file and update in Different Column...

    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...
  2. W

    Special characters in .txt file change during a Line Input in VBA

    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...
  3. M

    Read unicode from html file by VBA

    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...
  4. O

    Problem with putting an "TxT" file help fast!!!

    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 &...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top