Using Server 2003, while not logged in, I tested a scheduled task using a Batch file.
The Batch file called GridView with the /XDW parameter. GridView autoloads and refreshes 4 Views then exports those views to Excel. Lots of screen activity when logged in but the scheduled task worked correctly ( with no screen activity ) when NOT logged in.

I did need to restart the server to get the scheduled task to work.

I will put some simlpy VB script together to test ODBC but I do not think screen output is a problem.