Hello:

By adding the code

ActiveWorkbook.Save
ActiveWorkbook.Close

it gives Run Time erroe '1004
Method Save' of object '_Workbook' failed.

I would appreciate if you could try and let me know.

Once again thank you for your help.

Riz