Get data from all workbooks in folder

**Tortus** · 12-03-2008, 02:32 PM

A while back someone helped me out with a code to pull data out of all workbooks in a folder. This is the code

Please Login or Register  to view this content.

This code works flawless!

What I thought I could do with this code is create another file with this code, change a few things and have it work in another folder with a bunch of files pulling infromation from cells...(Clear as mud?) Well, it's not that easy I guess... for a nub anyway

What can I do to make this code work for different files? The files I am working with in a folder now are named like this 01-02-08_All.xls. Only the date changes in the nameing. Sorry I don't remember exactly who wrote this code but I think it was that really smart guy "Ross" but I could be wrong. Found the old post.. it was that elite Richard Buttrey that first helped me with this code!

**Kenneth Hobson** · 12-03-2008, 04:27 PM

If you are just needing the same but for another folder other than your workbook's path with that code, change:

Please Login or Register  to view this content.

to your path, something like:

Please Login or Register  to view this content.

**Tortus** · 12-03-2008, 05:20 PM

What I changed was the name of the sheet from

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Even thought the file names are different, does it matter?
I do not get a debug or any errors, it just doesnt bring anything from the other spreadsheets in the folder.

**Kenneth Hobson** · 12-03-2008, 05:31 PM

You need to step through the code with F8 to see if it doing what you think. You have a typo for one of your sheet names count.

**Tortus** · 12-03-2008, 05:59 PM

its spelt right in the code... i just missed it here

when I step through the code I don't see anything wrong and the only thing different is the file names in the folder

I've moved both files to a seperate folder to work through the problem. So, I have 2 workbooks in one folder. One workbook has the code attached to a button and the other has data. When I press the button, cells from sheet "counts" E3, E4, E5 should appear!

**Kenneth Hobson** · 12-03-2008, 06:27 PM

Try this on backup copies. I haven't tested this. It probably needs a bit more testing. The other code was checking for a pattern. The "*_All.xls" shold be sufficient.

Please Login or Register  to view this content.

**Tortus** · 12-04-2008, 12:51 PM

That code didn't work. Did the same thing.

All the files in this folder are named "MM-DD-YR_All.xls" except the file I'm using the code with.

I would like to pull these cells from the "counts" sheet in every file in this folder.

E3,E4,E5... through E19. Seperatly so not E3:E19

**ravishankar** · 12-04-2008, 11:45 PM

Hi
Save the attached file in the folder where you want the data from and run the macro.
Ravi

**Tortus** · 12-05-2008, 12:37 AM

That was cool. I looked at the code and I'm trying to figure out what I can change to make other colums appear in this sheet.

So If I wanted B, C, D, E, F to come in from all the workbooks, what has to change?

Update.... I figured it out but what I can't figure out is how to make it skip down the page a couple of rows before running the next macro. After pulling in C.. skip a few rows and pull in D.. skip a few rows....etc. I copied the macro and renamed it, then replaced all the "e" with "c" but it is over writing the "e"