I have a asp.net application in which i am downloading Excel files that are saved as BLOB in SQL database. These files use their file name in the Workbook_Open method to fill in some cells in the sheet to create templates. I am able to download file with the correct file name if i click 'Save' in the file download dialog and then open the file. This create one extra step for the user....
Is there any way by which i can click 'Open' button in the file download dialog and it gives the correct filename to the downloaded file instead of the name of the .aspx page that i am using in downloading?
Thanks in advance for all the help.
Here is my code
If myReader.Read Then
Dim fileName As String
Dim buffer() As Byte = Nothing
fileName = "Test Data-" & myPartID
Response.ContentType = "application/vnd.ms-excel "
Response.AddHeader("Content-Disposition", "attachment; filename=" + fileName)
buffer = myReader("DataExcel")
View Complete Post