summery excel book

[Sharp]

Hi,

this is a bit of a big ask.....but is it possible to do the following??

I have a folder full of excel files, that people will continue to add to. Is there a way that i can set-up an excel file that will summise all the other excel files in the folder.

For example can i bring back cell a1 for every excel book in the folder in this summary file and evertime someone adds a file to the folder it will update. I know i could go through manually and carry out vlookups, but there will be alot of files, so wondered if this could be done automatically. Any help or ideas would be much appreciated. Thanks in advance

[VBA Noob]

Hi,

This link should help

http://www.rondebruin.nl/ado.htm#folder

VBA Noob

[Sharp]

Hi,

thats great thanks for the help. I've almost got it doing what i need it to.

I'm using the

"Copy a range from all files in a folder and subfolders (optional)"

option from the link you sent me.

I don't suppose you could help with the following:

(1) when it copies to the database file it starts in a1 and works down. Is there a way to make it work accross (by column)

(2) i want to select the following range, but it will not let me input multiple ranges:

A1:A2
K5:K6
m24:M25

thanks