Merge excel files
 

I have approx 25 different excel file that i woul like to merge into one
file. Is this possible?

Merge excel files
 

It's possible yes. Do you want to copy the sheets from these files into one
file, or do you want to extract info from these into one worksheet?

--
HTH

Kassie

Replace xxx with hotmail


"The Rook" wrote:

I have approx 25 different excel file that i woul like to merge into one
file. Is this possible?

Merge excel files
 

Hi

I want to copy all the sheets to one file

"Kassie" wrote:

It's possible yes. Do you want to copy the sheets from these files into one
file, or do you want to extract info from these into one worksheet?

--
HTH

Kassie

Replace xxx with hotmail


"The Rook" wrote:

I have approx 25 different excel file that i woul like to merge into one
file. Is this possible?

Merge excel files
 

I take it you still want each sheet seperate?

If so, insert sheets in your file. Now open each of the other files, click
on the sqaure above A and to the left of 1, press <Ctrl<C, go the the
destination sheet, click in A1, and press <Ctrl<V.

If you want to copy into one sheet, click on A1 in the source sheet, press
and hold <Shift, and click <End & <Home to select the used range of that
sheet. <Ctrl<C, back to the destination sheet, press <End<Home, then
down arrow, then <End<Left, then <Ctrl<V
--
HTH

Kassie

Replace xxx with hotmail


"The Rook" wrote:

Hi

I want to copy all the sheets to one file

"Kassie" wrote:

It's possible yes. Do you want to copy the sheets from these files into one
file, or do you want to extract info from these into one worksheet?

--
HTH

Kassie

Replace xxx with hotmail


"The Rook" wrote:

I have approx 25 different excel file that i woul like to merge into one
file. Is this possible?

Merge excel files
 

See
http://www.rondebruin.nl/fso.htm


--

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




"The Rook" wrote in message ...
Hi

I want to copy all the sheets to one file

"Kassie" wrote:

It's possible yes. Do you want to copy the sheets from these files into one
file, or do you want to extract info from these into one worksheet?

--
HTH

Kassie

Replace xxx with hotmail


"The Rook" wrote:

I have approx 25 different excel file that i woul like to merge into one
file. Is this possible?

Merge excel files
 

Thanks for that, but unfortunatley I am not very good with VBA!

I have tryied to following the instructions for RDB_Copy_Sheet, I have
chenged the 'MyPath' to the file location, then run the macro, but get a
'Compile error: Sub or Function not defined' messge, and it highlights the
'Sub RDB_Copy_Sheet()' at the beginning of the macro.

Am I meant to change this to something or am I way of the mark?

"Ron de Bruin" wrote:

See
http://www.rondebruin.nl/fso.htm


--

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




"The Rook" wrote in message ...
Hi

I want to copy all the sheets to one file

"Kassie" wrote:

It's possible yes. Do you want to copy the sheets from these files into one
file, or do you want to extract info from these into one worksheet?

--
HTH

Kassie

Replace xxx with hotmail


"The Rook" wrote:

I have approx 25 different excel file that i woul like to merge into one
file. Is this possible?

Merge excel files
 

Managed got get the addins working, excellent piece of work but not exactly
what I wanted.

I want it to bring the worksheets from each file into one file (seperate
sheets)

But thanks anyway

regards

"Ron de Bruin" wrote:

See
http://www.rondebruin.nl/fso.htm


--

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




"The Rook" wrote in message ...
Hi

I want to copy all the sheets to one file

"Kassie" wrote:

It's possible yes. Do you want to copy the sheets from these files into one
file, or do you want to extract info from these into one worksheet?

--
HTH

Kassie

Replace xxx with hotmail


"The Rook" wrote:

I have approx 25 different excel file that i woul like to merge into one
file. Is this possible?

Merge excel files
 

I will add this when I update the add-in

--

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




"The Rook" wrote in message ...
Managed got get the addins working, excellent piece of work but not exactly
what I wanted.

I want it to bring the worksheets from each file into one file (seperate
sheets)

But thanks anyway

regards

"Ron de Bruin" wrote:

See
http://www.rondebruin.nl/fso.htm


--

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




"The Rook" wrote in message ...
Hi

I want to copy all the sheets to one file

"Kassie" wrote:

It's possible yes. Do you want to copy the sheets from these files into one
file, or do you want to extract info from these into one worksheet?

--
HTH

Kassie

Replace xxx with hotmail


"The Rook" wrote:

I have approx 25 different excel file that i woul like to merge into one
file. Is this possible?

Merge excel files
 

Test the code in the workbook that you can download

--

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




"The Rook" wrote in message ...
Thanks for that, but unfortunatley I am not very good with VBA!

I have tryied to following the instructions for RDB_Copy_Sheet, I have
chenged the 'MyPath' to the file location, then run the macro, but get a
'Compile error: Sub or Function not defined' messge, and it highlights the
'Sub RDB_Copy_Sheet()' at the beginning of the macro.

Am I meant to change this to something or am I way of the mark?

"Ron de Bruin" wrote:

See
http://www.rondebruin.nl/fso.htm


--

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




"The Rook" wrote in message ...
Hi

I want to copy all the sheets to one file

"Kassie" wrote:

It's possible yes. Do you want to copy the sheets from these files into one
file, or do you want to extract info from these into one worksheet?

--
HTH

Kassie

Replace xxx with hotmail


"The Rook" wrote:

I have approx 25 different excel file that i woul like to merge into one
file. Is this possible?