Opening all files in directory

[whisperinghill]

I have a macro, I would like to run on all files in a directory. But I only want it to open one file, run a macro and then close it and open the next file until it is through with the directory or through with selected files, either one would work.

I am pretty sure something was posted like this, but I cannot seem to locate it.

Anyone point me in the right direction?

[VBA Noob]

Hi,

This any help

http://support.microsoft.com/kb/139724


VBA Noob

[whisperinghill]

This any help

Yes it does thanks VBA Noob

Though I found one alittle easier to maniupulate from the same source.

Here is Macro to remove headers in all wqord documents in the current directory. Just have to open one Word Doc in that directory and then trigger the Macro Cooooool

Thanks

Please Login or Register  to view this content.

[VBA Noob]

Glad it helped

VBA Noob