I've never coded in Excel like that, do you have code for capturing the
information from open workbooks?



"Ron de Bruin" wrote:

See the links to the code pages on the bottom of the page

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"gkarasiewicz" wrote in message ...
Hello

I have tried to install this however it says that it's not a valid add-in.
Perhaps it's that i'm on a network and dont' have the necessary system
rights. So this option could have been and option had it worked on our system.

Is there a code version that i can compile on my end and try that?

"Ron de Bruin" wrote:

Start on my site gkarasiewicz

You can find a add-in and code
This is the link to the add-in
http://www.rondebruin.nl/merge.htm



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"gkarasiewicz" wrote in message
...
Hello here is my situation. I have a directory of excel workbooks, in each
work book it has 3 sheets. I need two pieces of data from each sheet:

The outputted information in Merged cells B3-5
And
The text in merged cells E-H3

The Directory that these files are in are like this :
2007/WE Sept 1/FileName.xls
2007/WE Sept 8/FileName.xls

in the 2007/WE Sept 1/ directory there are about a hundred files each with a
unique FileName

Is there a way to open all these pull this information and have it put into
one spreadsheet?