Download excel file without prompt for user

Please type an email. Please type a Name. I want more news and awesome tips. WizCase Downloads Excel Microsoft Our Reviews WizCase includes reviews written by our experts.

Referral fees Wizcase may earn an affiliate commission when a purchase is made using our links. Search the community and support articles Microsoft and Office Search Community member.

This thread is locked. You can follow the question or vote as helpful, but you cannot reply to this thread. I have the same question Report abuse. Details required :. Cancel Submit. How satisfied are you with this reply? Thanks for your feedback, it helps us improve the site. In reply to Chris. After much frustration trying to resolve the Workbook Save on Close without prompts, I seem to have found the cause.

Once cleaned up, the Workbook Save on Close works without having to disable alerts or such. Posted Jun am Member Add your solution here. OK Paste as. Treat my content as plain text, not as HTML. Existing Members Sign in to your account. This email is in use. Do you need your password? Submit your solution! When answering a question please: Read the question carefully. Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.

If you have feedback for TechNet Subscriber Support, contact tnmff microsoft. Office Office Exchange Server. Not an IT pro? Resources for IT Professionals. Sign in. I would like when a user clicks a button for exporting a datagrid, that the excel file is saved on the server and that it DOES NOT prompt the user to open or save. Here is the code I am using for standard export that prompts the user. Thanks all. Write myTextWriter. ToString 'End the response Response.

Follow Post Reply. Norman Yuan. Where do you exactly want to save the Excel file? On ther server, as you mentioned in the beginning of your post, or on user computer, as your code shows? Data from web server is not allowed to silently save data to user's computer, for safety reason. You need entirely different code to save the data on the server, if that is what you want. Steve C. It seems you want to save the HTML to a file instead of writing it out to to the response.