How can I combine several excel files into one?

[Crystal Lee]

I have 20 excel files and each excel file contains 3 worksheets. How can I
combine these files into one by only a few clicks?

In the past, I did it by right click 'move or copy' and one by one.

 

[Pecoflyer]

I have 20 excel files and each excel file contains 3 worksheets. Ho
can I
combine these files into one by only a few clicks?

In the past, I did it by right click 'move or copy' and one by one.

Hi,

there are some nice solutions at 'this site
(http://www.rondebruin.nl/copy3.htm)

HT

--
Pecoflye

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows fil
upload ->faster and better answer

 

[Crystal Lee]

But I don't have the right to install anything on my desktop. So, there is
no chance, right?

Thanks again.

 

[Pecoflyer]

But I don't have the right to install anything on my desktop. So, ther
is
no chance, right?

Thanks again.


The Code Cage Forums
(http://www.thecodecage.com/forumz/showthread.php?t=52748)

Ron's site provides macro's, so you can install them yourself in XL, o
is this possibility blocked

--
Pecoflye

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows fil
upload ->faster and better answers

*Adding your XL version* to your post helps finding solution faste