Get data from multiple files in multiple folders

wilster98

New Member
Joined
May 11, 2016
Messages
20
I am wanting to pull data from multiple closed files, in multiple folders.
When we measure parts on our CMM (Coordinate Measuring Machine), the data is output to an Excel file in it's own folder. What I want to do is pull data from these files, within a specified date range and put all measurements into one file. Once I have this data, I can do the analysis I need to do. Is it possible to do this? The file names for the source files follow a specific naming convention, and in each file, the data I need to extract start at the same cell address, so there are consistencies. I have no control of how the data is saved, so a different structure is not an option.

This will be the beginning of a pretty large project.

Thanks in Advance
Willy
 

Some videos you may like

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

ranman256

Well-known Member
Joined
Jun 17, 2014
Messages
1,971
is it supposed to pull ALL workbooks in a set of folders?
or
just certain files in certain folders and not every time?
 

wilster98

New Member
Joined
May 11, 2016
Messages
20
Just certain files, and not all the time. Some of the files in the folders are not Excel files, and some of the Excel files contain data I do not want. It's a bit of a challenge. I am trying to automate a data reporting process.
 

Watch MrExcel Video

Forum statistics

Threads
1,127,560
Messages
5,625,507
Members
416,115
Latest member
Gonzo5711

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top