In searching of the (excel) VBA code to monitor folder, I found a good piece written by Excel. Please refer:

http://www.vbusers.com/downloads/download.asp#item18

It works well. But I want to have more: how can it also monitor any change in sub-folder?

Thanks!