You don't show how your Macro is triggered, but if you want what you state above, then you do NOT want to use a For Each Action on all files in the folder.
For a good example, see
You don't show how your Macro is triggered, but if you want what you state above, then you do NOT want to use a For Each Action on all files in the folder.
For a good example, see