VBA [Excel 2007] to SQL Server [9.0]

Hi All,

I have seen many forums with similar posts, however, I have not come across a reply that works.

Systems Overview
- Excel 2007
- SQL Server 9.0

Process Overview
- Have established a SQL View (sql query that is published without parameters) which is outputs to Excel via External Data Source via SQL Server menu.
- SQL View outputs 400,000 rows every time I run the query into Excel via "External Data Source" via "SQL Server"

Request
1. Require VBA code to paramterise the SQL view on selected fields; or
2. VBA code to establish an parameter query through an ADO/DAO connection, build the query and output the results to Excel sheet.