How to build build a macro that automatically imports
 

Hi,

I want to build a macro that imports all the txt files that are placed
in a specified directory. The text files are all the same, importing
from colomn 6 and onwards. The data from the files must be placed under
eachother.

how to do it?

problem#2:I want to calculate with the data from the text files, how do
i make excel arrange all the data that relates to a specific value.
example:
name points
Fred (textfile#1) 12
Ralf (textfile#1) 14
Guv (textfile#1) 11
Fred (textfile#2) 24
Ralf (textfile#2) 24
Guv (textfile#2) 88
Fred (textfile#3) 27
Ralf (textfile#3) 14
Guv (textfile#3) 19

I want excel to show this data as:
Fred 1 12
Fred 2 24
Fred 3 27
Fred total: 63
Fred average: 21

the same for Ralf en Guv....

any suggestions?

Thanks in advance!


---
Message posted from http://www.ExcelForum.com/

How to build build a macro that automatically imports
 

Pedro,

I need to know how you write data to text files to show
You how read it and put it to Excel.


-----Original Message-----
Hi,

I want to build a macro that imports all the txt files
that are placed
in a specified directory. The text files are all the
same, importing
from colomn 6 and onwards. The data from the files must
be placed under
eachother.

how to do it?

problem#2:I want to calculate with the data from the text
files, how do
i make excel arrange all the data that relates to a
specific value.
example:
name points
Fred (textfile#1) 12
Ralf (textfile#1) 14
Guv (textfile#1) 11
Fred (textfile#2) 24
Ralf (textfile#2) 24
Guv (textfile#2) 88
Fred (textfile#3) 27
Ralf (textfile#3) 14
Guv (textfile#3) 19

I want excel to show this data as:
Fred 1 12
Fred 2 24
Fred 3 27
Fred total: 63
Fred average: 21

the same for Ralf en Guv....

any suggestions?

Thanks in advance!


---
Message posted from http://www.ExcelForum.com/

.