open files run macro

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

 

[Ron de Bruin]

Hi Steve

Use this macro
http://www.rondebruin.nl/copy4.htm

Read the examples below the macro

 

[Steve]

Is there a way to process workbooks in all sub-folders, too?

 

[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