Hi Paul

Still having the issue when i try to run the macro. I am just open the empty macro enabled workbook and paste the code and run it. Both workbook and doc file placed in the same path.

Is this right way?

If not, can you please tell me the way to run?