Creating a list, from data in a bunch of different files

**Sibrulotte** · 11-24-2009, 04:23 PM

Hi,
couldn't find anything searching on my thread topic.

I have forms filled out by many, and I need to compile the information in it to create a list in my summary.

Is that possible?

fortunatly, the information always resides in the same cell on every file.

**Leith Ross** · 11-24-2009, 08:09 PM

Hello Sibrulotte,

I have forms filled out by many, and I need to compile the information in it to create a list in my summary.

Is that possible?

Yes, it is possible.

**jaslake** · 11-24-2009, 10:08 PM

Hi Sibrulotte
If you're willing to attach several workbook examples of your source files and a sample of what you wish the results to look like, I'd be glad to look at it.
John

**Sibrulotte** · 11-25-2009, 03:09 PM

there you go.

Thank you,
I was looking for a clue on where to start, so I didn't figure attachments we're necessary. Thanks for not being a wiseass...
very appreciated.

**jaslake** · 11-25-2009, 03:29 PM

Hi Sibrulotte
Will all of these forms be in the same folder? If so, will there be other files in the folder where these forms reside? Will the Summary file exist in this same folder or another folder? Most importantly, what will the Summary sheet look like? Fill out a Summary sheet with headings and data from one of the forms you posted.
John

**Sibrulotte** · 11-25-2009, 03:42 PM

I think you're going above the call of duty, but I'm more than happy about that.
Here's what I need to transfer

From the forms: to the summary

Désinstallation (numéro burinage) : # de burinage
No. Véhicule: No. Véhicule
Bon DGRT: Bon DGRT
Installation nouveau matériel (date) : Date de désinstallation

Yes they will all be in the same folder, and there will be no other files in this folder. Attached is the summary, with the data from one of the forms.

CHEERS!

**jaslake** · 11-25-2009, 04:56 PM

Hi Sibrulotte
The attached file contains the following code:

Please Login or Register  to view this content.

The code runs from Sommaire and opens all excel files in it's path and merges the prescribed data. Please note that Reference to Microsoft Scripting Runtime must be set Tools->References-> select Microsoft Scripting Runtime.
If you have any issues, let me know.
John