Apply VBA function to multiple excel files

[mate]

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.

 

[Bob Phillips]

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)

 

[Bob Phillips]

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)