beautiful_mind
New Member
- Joined
- Oct 30, 2013
- Messages
- 1
Hello.
I'm new to macro and it would be vey kind of anyone to help me with my problem.
So I have several text files in a folder, all with the same format.
Like this;
--------------------------
File Information
--------------------------
File Name: , XXXXX
File Type: ,XXXX
Comment: ,none
--------------------------
Concentration Table
--------------------------
A1 , A2 , A3 ,
0.314 , 0.499 , 0.733 ,
70.185 , 111.580 , 163.969 ,
79.40 , 16.14 , 4.46 ,
-----------------------------------
Can anyone teach me how to make a macro that can separate these A1, A2 and A3 data into different rows and column and to repeat the process for all the text files in the folder
Thank you in advance!
I'm new to macro and it would be vey kind of anyone to help me with my problem.
So I have several text files in a folder, all with the same format.
Like this;
--------------------------
File Information
--------------------------
File Name: , XXXXX
File Type: ,XXXX
Comment: ,none
--------------------------
Concentration Table
--------------------------
A1 , A2 , A3 ,
0.314 , 0.499 , 0.733 ,
70.185 , 111.580 , 163.969 ,
79.40 , 16.14 , 4.46 ,
-----------------------------------
Can anyone teach me how to make a macro that can separate these A1, A2 and A3 data into different rows and column and to repeat the process for all the text files in the folder
Thank you in advance!
