import data text

  1. T

    Import text file as UTF-8

    I am using the following vba code to import all txt files in the active directory into excel. Sub ImportTXTfiles() Dim Path As String Path = Application.ActiveWorkbook.Path & "\" Filename = Dir(Path & "*.txt") Do While Filename <> "" Workbooks.Open Filename:=Path & Filename, ReadOnly:=True For...
  2. S

    Importing Multiple Text Files into Excel from Multiple Folders

    Hi I am not a Macro developer so not that advanced at that stuff but I need help importing data from multiple .text files into a single excel sheet. The problem I face is as follows: 1. I have 100+ folders each with a unique name but each contains a text file with the same name which is...
    • Shengate
    • Thread
    • .text import data text macro multiple folders source path
    • Replies: 1
    • Forum: Excel Questions
  3. F

    Importing timestamps with milliseconds

    I try to import an instrument log with timestamps in format YYYY-MM-DD hh:mm:ss.sss into Excel. Whenever the first digit after the decimal separator is a zero, Excel doesn't recognise the value as valid date time, but import it as text. E.g. "2014-11-27 03:38:34.853" is imported as time, but...
    • farnol
    • Thread
    • import data text milliseconds time timevalue
    • Replies: 5
    • Forum: Excel Questions
  4. D

    External Data Import .TXT File

    I am attempting to import external .TXT files into Access using an established Fixed Width Import Specification format. When doing this I am running into issues where the data file is being imported without maintaining the data file's sequential structure. I have attempted to do this on numerous...
  5. H

    Import text from a text file between 2 sentences

    Hello, I want to import certain text from a text file which is between 2 sentences. Sample text:- ****Begin: 8.3 Naming Convention Path: HKLM\system\currentcontrolset\control\filesystem\ntfsdisable8dot3namecreation Value: 0 Interpretation: 8.3 Naming Convention enabled ****End: 8.3 Naming...
    • hunk_1990
    • Thread
    • import import data text import data vba import selected data vba
    • Replies: 0
    • Forum: Excel Questions

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
Back
Top