I think this article is a copy from http://www.mssqltips.com/tip.asp?tip=1426, So lets give some credit to that.

It works Ok, but do agree with the others that Excel is not the best way to use it. Reporting services and a SQL Job will be the best way to use it, instead of relying on Excel to register values.