Hi Andy,

I will try it tomorrow and see how it goes.

FYI, i did create another new folder in my desktop with different filenames and to see whether the macro (the one you provided yesterday) can be executed or not. Unfortunately, no message box also.

Today, i just zipped up those files one by one and it took me about one hour. I really hope your macro can run at my workplace PC so that i can have an easier life.

How come it works in my home PC but not office PC?

Thanks