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.
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?