Macro to loop through all files in a folder

I'd do something like this:

Please Login or Register  to view this content.

Thanks so much for the quick response!! That seems to work great.

I should have mentioned in the original post that the 'Reports' folder will often have sub-folders within it. So is there a way to change the code so that the Directory in the first line can be selected through an open file dialogue box or something? Or is there another way to do this without having to change the actual code every time?

Thanks again

Just have the path in a string variable (populated however you like) and then have the code say something like:

Please Login or Register  to view this content.

And

Please Login or Register  to view this content.

Thanks again for your help Andrew.

I didn't really understand what you meant before but after playing around with the macro a bit more it works exactly the way I want it to with the following code:

Please Login or Register  to view this content.

So I can now select more than one file to open at a time in whatever folder I want and loop through the selected files to open them.