Excel Import Macro
 

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?

Excel Import Macro
 

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?

Excel Import Macro
 

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?

Excel Import Macro
 

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?

Excel Import Macro
 

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?

Excel Import Macro
 

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

No, i always open the books with code

Download the example workbook from my FSO page and let me know if you have problems
http://www.rondebruin.nl/fso.htm

--

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


"gkarasiewicz" wrote in message ...
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?