To join some sheets of several files in one file
 

Dear friends,
Every month, I have to print a report that is made by several sheets
These sheets are contained in more files .xls. I would like to write
macro for joining more files in one. For example, in the folder “Pippo
(C:\Documents\Pippo) there are 3 files (A, B, C). Every files is mad
by several sheets. I would like to create the file “Pluto which shoul
be made by some sheets contained in the files A, B,C. I would like t
save “Pluto” in the folder “Pippo”.
After this operation, the macro should print all sheets contained i
the new file “Pluto”. Before lunching the print, the macro shoul
number the pages (for these last operation you have to consider th
possibility that a excel sheet could be print in more pages).
Is all that possible?
Thank you very much for your help
Ciao
Paol

--
Message posted from http://www.ExcelForum.com

To join some sheets of several files in one file
 

Start with this example
http://www.rondebruin.nl/copy3.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl


"71paolo71 " wrote in message ...
Dear friends,
Every month, I have to print a report that is made by several sheets.
These sheets are contained in more files .xls. I would like to write a
macro for joining more files in one. For example, in the folder "Pippo"
(C:\Documents\Pippo) there are 3 files (A, B, C). Every files is made
by several sheets. I would like to create the file "Pluto which should
be made by some sheets contained in the files A, B,C. I would like to
save "Pluto" in the folder "Pippo".
After this operation, the macro should print all sheets contained in
the new file "Pluto". Before lunching the print, the macro should
number the pages (for these last operation you have to consider the
possibility that a excel sheet could be print in more pages).
Is all that possible?
Thank you very much for your help
Ciao
Paolo


---
Message posted from http://www.ExcelForum.com/