Download Excel File and Pass a Parameter?

Question

Hello,

I'm working on an Intranet application and need to populate an Excel file with data from a SQL server database.

I do not want to use automation on the web server.

Is there a way to pass a record ID parameter (like a querystring in the hyperlink) when I download the file?  I want to reference the ID and populate the form from the browser via Excel VBA.

Appreciate any advice.

Thanks!

-Duke

Answer 1

Will any portion of your application be running on client machines? or will this all be server-side?