Hello everyone,
Thanks Hui and Chihiro give me some idea to calculate data in csv file
(my last project VBA).
Now I want to make a general project (it can process with many folder, sub folder include more file inside).
So I explain my Idea :
I have a source folder include 6 sub folder inside ex : "A","B","C","D","E","F".
Each folder of (A,B,C,D,E,F) has many sub folder and file inside.
I looking for 2 type of file : *.dat and *.csv .
One information : *.dat file is inside folder name "count" and *.csv file inside
...\csv\folder name\
example : C:\DATA\A\A1\...\count\file1.dat
C:\DATA\B\B1\...\csv\folder1\file1.csv
my solution is list all folder and sub folder of source C:\DATA
check all path name, if it is end by "count" call Function calculate dat
.....
Finaly,make 6 sheet ( named A,B,C,D,E,F) each sheet include data count from file inside
day number of FAIL number of PASS
1 ? ?
2
3
...
31
The post http://forum.chandoo.org/threads/ge...hout-opening-it-have-error.35262/#post-211111 I make function to calculate csv file.
May be it is difficult to understand, if you have any question please ask me.
Thank everyone so much.
Thanks Hui and Chihiro give me some idea to calculate data in csv file
(my last project VBA).
Now I want to make a general project (it can process with many folder, sub folder include more file inside).
So I explain my Idea :
I have a source folder include 6 sub folder inside ex : "A","B","C","D","E","F".
Each folder of (A,B,C,D,E,F) has many sub folder and file inside.
I looking for 2 type of file : *.dat and *.csv .
One information : *.dat file is inside folder name "count" and *.csv file inside
...\csv\folder name\
example : C:\DATA\A\A1\...\count\file1.dat
C:\DATA\B\B1\...\csv\folder1\file1.csv
my solution is list all folder and sub folder of source C:\DATA
check all path name, if it is end by "count" call Function calculate dat
.....
Finaly,make 6 sheet ( named A,B,C,D,E,F) each sheet include data count from file inside
day number of FAIL number of PASS
1 ? ?
2
3
...
31
The post http://forum.chandoo.org/threads/ge...hout-opening-it-have-error.35262/#post-211111 I make function to calculate csv file.
May be it is difficult to understand, if you have any question please ask me.
Thank everyone so much.