Hi guyz,
Please excuse me if this question has already been asked multiple times. I am very bad with the VBA Scripting and would appreciate any and all help with my query here.
So, what do I need help with?
I have a folder in my C:\ Drive with the name "Acc". In this folder I have Multiple Workbooks. What I am currently looking for is a way to extract a specific Cell content namely L38, from all the workbooks in the folder (this is basically a net value).
I want all of these to be listed in my "Ledger" excel workbook. So, the scenario is pretty much like this:
"Test1.xlsx" Cell Value L38
"Test2.xlsx" Cell Value L38
"Test3.xlsx" Cell Value L38
"Test4.xlsx" Cell Value L38
And all of these values being listed in a column format (like L38 Value from Test1 is in A1, so on and so forth) in my Ledger.xlsx file. It would be great if someone can help me with this query and provide me with a dynamic (possibly - reusable) code to get this done.
Thank you in advance.
Please excuse me if this question has already been asked multiple times. I am very bad with the VBA Scripting and would appreciate any and all help with my query here.
So, what do I need help with?
I have a folder in my C:\ Drive with the name "Acc". In this folder I have Multiple Workbooks. What I am currently looking for is a way to extract a specific Cell content namely L38, from all the workbooks in the folder (this is basically a net value).
I want all of these to be listed in my "Ledger" excel workbook. So, the scenario is pretty much like this:
"Test1.xlsx" Cell Value L38
"Test2.xlsx" Cell Value L38
"Test3.xlsx" Cell Value L38
"Test4.xlsx" Cell Value L38
And all of these values being listed in a column format (like L38 Value from Test1 is in A1, so on and so forth) in my Ledger.xlsx file. It would be great if someone can help me with this query and provide me with a dynamic (possibly - reusable) code to get this done.
Thank you in advance.
