7
71paolo71
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
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