import data from txt files

Some videos you may like

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

dgpenny

New Member
Joined
Jan 1, 2004
Messages
46
As a somewhat newbie to Excel myself I can relate to the dilemma by the poster. However, I can attest to the fact that this board is for "HELP when stumped" not "do it for me." You can never learn without trying it yourself first. My two cents.
 

XLGibbs

Well-known Member
Joined
Feb 25, 2005
Messages
2,446
That is true, it is tough to find someone to start from scratch and simply do the work.

One step at a time...you can use the macro recorded (Tools>Macro>Record macro)

to record the code that does the import. In many cases that code can be modified to help you out, but you kind a gotta start somwhere.

Since we do not know
1) How many text files
2) What format the text files are in (comma delimited, fixed width) etc
3) The format they need to be in excel

etc

it is very difficult, as there is no "blanket" code for something like this.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,910
Messages
5,574,994
Members
412,633
Latest member
simon_elvin
Top