How to automate SQL Server Management Studio Standard Reports
I'm trying to automate the excel export version of all of the standard SQL Server Management Studio reports.  Currently I manually open management studio and select each DB and export the reports weekly.  It doesn't look like the ssms.exe has a command line switch do so and I did not see it exposed in the SMO API.

Also I'd like the solution to be as lightweight as possible, so that rules out SSMS.
How to automate SQL Server Management Studio Standard Reports
===

I'm trying to automate the excel export version of all of the standard SQL Server Management Studio reports.  Currently I manually open management studio and select each DB and export the reports weekly.  It doesn't look like the ssms.exe has a command line switch do so and I did not see it exposed in the SMO API.

Also I'd like the solution to be as lightweight as possible, so that rules out SSMS.