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.

Automating a report
 

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" skrev i melding
...
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.

Automating a report
 

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" wrote in message ...
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.

Automating a report
 

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" wrote in message ...
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.