Write macro to import many .txt files?

[kre1973]

I have a folder that contains many .txt files that I need to import into Excel. Every .txt file would have it's own indivdual sheet based on the name of the text file.

With every .txt file there are records within it that would put imported into rows which are delimited by the pipe symbol "|" starting in row 2.


thanks

 

[SkipVought]

hi,

Have you turned on your macro recorder, and recorded doing a Data > Import External Data > Import?

You can specify the pipe as a delimiter and the starting row.

Post back with your recorded code if you need further help.

Skip,
[sub]
Have you heard that the roundest knight at King Arthur's round table was...
Sir Cumference![/sub]

 

[kre1973]

I actually want ot use Excel VBA code...

 

[macropod]

Hi kre1973,

I actually want ot use Excel VBA code...

That's what the macro recorder produces.

Cheers

[MS MVP - Word]

 

[AnotherHiggins]

In case you're looking for it, Tools > Macro > Record New Macro

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.