I have a function that transfers the values in certain
cells to a new worksheet. I recieve around 10 of these
identical layout, but separate files each day. Is there a
way to apply the function to all the excel files instead
of having to write the code for each separate file? any
help would be great. thanks, mate.

You could add a toolbar button to your

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"mate" wrote in message
...
I have a function that transfers the values in certain
cells to a new worksheet. I recieve around 10 of these
identical layout, but separate files each day. Is there a
way to apply the function to all the excel files instead
of having to write the code for each separate file? any
help would be great. thanks, mate.

You could add a toolbar button to a macro in your Personal.xls and then
just open the ss and click the button.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"mate" wrote in message
...
I have a function that transfers the values in certain
cells to a new worksheet. I recieve around 10 of these
identical layout, but separate files each day. Is there a
way to apply the function to all the excel files instead
of having to write the code for each separate file? any
help would be great. thanks, mate.