REVscene Automotive Forum - View Single Post - Advanced Excel Q - Fetching Cell Values from Multiple .xls files

Ferra · 10-14-2010, 01:58 PM

Say I have a folder with 1000 excel files in a standard "form" format, and each has different values in the form.

Is there any functions or VBA I can use to automatically fetch a particular cells values (e.g. A5, C8..etc) from all 1000 excel files? (and consolidate them into a list of values on one spreadsheet)

10-14-2010, 01:58 PM	#1
Ferra I don't like cheese but I love milk! Join Date: Nov 2002 Location: Van Posts: 1,980 Thanked 895 Times in 243 Posts Failed 105 Times in 49 Posts	Advanced Excel Q - Fetching Cell Values from Multiple .xls files Say I have a folder with 1000 excel files in a standard "form" format, and each has different values in the form. Is there any functions or VBA I can use to automatically fetch a particular cells values (e.g. A5, C8..etc) from all 1000 excel files? (and consolidate them into a list of values on one spreadsheet)