| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
open files run macro
I want to run a macro (sets headers/footers) on every workbook in a directory
structure and have the post-macro worbook saved. Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
open files run macro
Hi Steve
Use this macro http://www.rondebruin.nl/copy4.htm Read the examples below the macro -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Steve" wrote in message ... I want to run a macro (sets headers/footers) on every workbook in a directory structure and have the post-macro worbook saved. Thanks. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
open files run macro
Is there a way to process workbooks in all sub-folders, too?
"Ron de Bruin" wrote: Hi Steve Use this macro http://www.rondebruin.nl/copy4.htm Read the examples below the macro -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Steve" wrote in message ... I want to run a macro (sets headers/footers) on every workbook in a directory structure and have the post-macro worbook saved. Thanks. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
open files run macro
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 -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Steve" wrote in message ... Is there a way to process workbooks in all sub-folders, too? "Ron de Bruin" wrote: Hi Steve Use this macro http://www.rondebruin.nl/copy4.htm Read the examples below the macro -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Steve" wrote in message ... I want to run a macro (sets headers/footers) on every workbook in a directory structure and have the post-macro worbook saved. Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| hidden macro affects how other files open | Excel Discussion (Misc queries) | |||
| Macro - Open all word files in a directory | Excel Worksheet Functions | |||
| Open several text files using a macro | Excel Discussion (Misc queries) | |||
| Macro to open files isn't updating correctly | Excel Discussion (Misc queries) | |||
| Macro for multiple open files | Excel Discussion (Misc queries) | |||
Linear Mode
