blueSee72
06-03-2012, 01:59 PM
Hi all,
I am a newbie and desperately need some help. I really hope that one of you can help me here.
I'm writing a code where I want to go through a lot of folders and look for one. Xls file and from that file I want to present the results in another xls file.
So far I've managed to go through all folders and print the name of the folders that have the target file and write it in the new xls sheet.
Information that I want to retrieve from the target file are from column A, B, I, row 11 and sheet 4.
The list of information to be retrieved is long, approximately 200 rows. The result excel file contains the header in column A, B and I and the data stored in each column. Then I want to be able to go through all the folders that particular xcel file, and retrieve data from the same columns and present them in the new file called "summering".
I really appriciate your help. I am stucked right now :(
Cheers
B
I am a newbie and desperately need some help. I really hope that one of you can help me here.
I'm writing a code where I want to go through a lot of folders and look for one. Xls file and from that file I want to present the results in another xls file.
So far I've managed to go through all folders and print the name of the folders that have the target file and write it in the new xls sheet.
Information that I want to retrieve from the target file are from column A, B, I, row 11 and sheet 4.
The list of information to be retrieved is long, approximately 200 rows. The result excel file contains the header in column A, B and I and the data stored in each column. Then I want to be able to go through all the folders that particular xcel file, and retrieve data from the same columns and present them in the new file called "summering".
I really appriciate your help. I am stucked right now :(
Cheers
B