Aug 6, 2008, 9:26 AM
Post #1 of 2
Create an excel file with different sheets for each text file from different folder
I need code for the following scenario.
i have a folder TestResult which has sub folders (Test0, Test1, Test2,......so on). These sub folders has 1 log file each which I wanted to be copied in different sheets of one excel workbook. So all the log files will be the sheets in one workbook.
Please if anybody could give it a try.