T
Thulasiram
Happy Friday to all the members!
I have a text box in the excel file where the user enters the path in
which many excel files are located. For example, if the user has 20
excel files in C:\files\data, then user would enter C:\files\data in
the text box and would click a command button.
If the command button is clicked, I am looking for the code that
would:
1. Locate all the files with *.xls extension
2. Fetch the data from the cells D7 and D8 from the first worksheet of
each excel workbook.
3. Paste those data in the new excel file in columns A and B starting
with A2 and B2.
i.e. D7 and D8 values from first excel file will go into A2 and B2; D7
and D8 values from second excel file will go into A3 and B3 and so
on.....
Can someone give some tips or code to accomplish this? I would deeply
appreciate this help.
Thank you very much.
I have a text box in the excel file where the user enters the path in
which many excel files are located. For example, if the user has 20
excel files in C:\files\data, then user would enter C:\files\data in
the text box and would click a command button.
If the command button is clicked, I am looking for the code that
would:
1. Locate all the files with *.xls extension
2. Fetch the data from the cells D7 and D8 from the first worksheet of
each excel workbook.
3. Paste those data in the new excel file in columns A and B starting
with A2 and B2.
i.e. D7 and D8 values from first excel file will go into A2 and B2; D7
and D8 values from second excel file will go into A3 and B3 and so
on.....
Can someone give some tips or code to accomplish this? I would deeply
appreciate this help.
Thank you very much.