See if my article Automating Excel from SQL Server[/url] helps you out. Be sure to read the discussion on this article for implications of doing this on your production server.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes