open files run macro

S

Steve

I want to run a macro (sets headers/footers) on every workbook in a directory
structure and have the post-macro worbook saved. Thanks.
 
R

Ron de Bruin

Yes this is possible

I not have time now to build a example but you can steal the code to build a array with all files
in the root and sub folders on this page (download the example workbook)
http://www.rondebruin.nl/fso.htm

If you have problems post back and I see if I have time this weekend
 
Top