Apply VBA function to multiple excel files

M

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.
 
B

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)
 
B

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)
 
Top