Automating a report

I would like to have suggestions on what's the best best way for resolving my
problem:

I have to turn in a report every week that consists of one summary sheet and
25 other sheets. The Summary sheet reads data from the Totals field in the 25
sheets and displays it. The 25 sheets are sent to me by the different
departments. I want a program so that I can save all the 25 sheets /
workbooks in one folder when I receive them from the departments and then run
the program that copies all the 25 sheets and the summary sheet template to a
new workbook and then do the linking between the summary sheet and the 25
sheets. Is there a way to do it without having to open all the 25 sheets and
then running the macro.

Thanks in advance.

Hi

Here's code that open/process/close all workbooks in a folder:
http://www.contextures.com/xlfaqMac.html#LoopBooks

HTH. Best wishes Harald

"sharman" <sharman@discussions.microsoft.com> skrev i melding
news:560CFFA4-7FE1-4700-A26D-481A0C5D23AE@microsoft.com...
> I would like to have suggestions on what's the best best way for resolving
my
> problem:
>
> I have to turn in a report every week that consists of one summary sheet
and
> 25 other sheets. The Summary sheet reads data from the Totals field in the
25
> sheets and displays it. The 25 sheets are sent to me by the different
> departments. I want a program so that I can save all the 25 sheets /
> workbooks in one folder when I receive them from the departments and then
run
> the program that copies all the 25 sheets and the summary sheet template
to a
> new workbook and then do the linking between the summary sheet and the 25
> sheets. Is there a way to do it without having to open all the 25 sheets
and
> then running the macro.
>
> Thanks in advance.

Hi sharman

See my site for examples
http://www.rondebruin.nl/tips.htm

>I want a program so that I can save all the 25 sheets /
> workbooks in one folder when I receive them from the departments
Which mail program do you use ?

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



"sharman" <sharman@discussions.microsoft.com> wrote in message news:560CFFA4-7FE1-4700-A26D-481A0C5D23AE@microsoft.com...
>I would like to have suggestions on what's the best best way for resolving my
> problem:
>
> I have to turn in a report every week that consists of one summary sheet and
> 25 other sheets. The Summary sheet reads data from the Totals field in the 25
> sheets and displays it. The 25 sheets are sent to me by the different
> departments. I want a program so that I can save all the 25 sheets /
> workbooks in one folder when I receive them from the departments and then run
> the program that copies all the 25 sheets and the summary sheet template to a
> new workbook and then do the linking between the summary sheet and the 25
> sheets. Is there a way to do it without having to open all the 25 sheets and
> then running the macro.
>
> Thanks in advance.

I am sorry for the delayed reponse as I was out of the country. I want
everything in excel and VB. Thanks.

"Ron de Bruin" wrote:

> Hi sharman
>
> See my site for examples
> http://www.rondebruin.nl/tips.htm
>
> >I want a program so that I can save all the 25 sheets /
> > workbooks in one folder when I receive them from the departments
> Which mail program do you use ?
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
>
> "sharman" <sharman@discussions.microsoft.com> wrote in message news:560CFFA4-7FE1-4700-A26D-481A0C5D23AE@microsoft.com...
> >I would like to have suggestions on what's the best best way for resolving my
> > problem:
> >
> > I have to turn in a report every week that consists of one summary sheet and
> > 25 other sheets. The Summary sheet reads data from the Totals field in the 25
> > sheets and displays it. The 25 sheets are sent to me by the different
> > departments. I want a program so that I can save all the 25 sheets /
> > workbooks in one folder when I receive them from the departments and then run
> > the program that copies all the 25 sheets and the summary sheet template to a
> > new workbook and then do the linking between the summary sheet and the 25
> > sheets. Is there a way to do it without having to open all the 25 sheets and
> > then running the macro.
> >
> > Thanks in advance.
>
>
>