First possible method, if you need to export data to excel only now and then:

Execute the query in MS SQL Management Studio, right klick on the result grid, save data...

Nice script. Just enjoyed it. If @dbname AS VARCHAR(20) is increased a bit in size, it starts working;)

Heinrich