Hi Homey,

Thanks for your reply as I just came back from holidays

After work around based on your codes, it doesn't work
Later, I found the codes below quite similar from other forums and it
works in excel 2007

If objFile.Type Like "Microsoft*Excel*Worksheet*" Then

Thanks anyway

Regards
Len