ConfusedSoul
New Member
- Joined
- Nov 16, 2016
- Messages
- 6
Hello good men and women!!
Please please help me resolve this urgent requirement!!
1. I have a shared drive with millions of folders ( some zipped, some not), containing different files ( extension as .dat, .csv, .log, .txt)
2. I need to: have an excel created with column headers populated as below for all files ( even those within zipped folders)
3. I have been adviced to copy each file on to my local and not open it from the shared drive ( basically not to blast the server with my incapable vba skills . TINGG :D)
HELP PLEASE???
Col A : File name including path
Col B..... COL whatsoever : First row of each file if it is an excel, csv or txt ( Basically after the headers in each file)
Please please help me resolve this urgent requirement!!
1. I have a shared drive with millions of folders ( some zipped, some not), containing different files ( extension as .dat, .csv, .log, .txt)
2. I need to: have an excel created with column headers populated as below for all files ( even those within zipped folders)
3. I have been adviced to copy each file on to my local and not open it from the shared drive ( basically not to blast the server with my incapable vba skills . TINGG :D)
HELP PLEASE???
Col A : File name including path
Col B..... COL whatsoever : First row of each file if it is an excel, csv or txt ( Basically after the headers in each file)