I am exporting data from the web to excel. Most of this is working fine, except that I get 2 prompts to “Open or Save” the file.
If I use this code I get 2 prompts:
Print |Content-Disposition:Attachment; Content-Type:application/vnd.ms-excel; filename=“| + DefaultFileName + |”|
If I use this line I only get 1 prompt, but the document opens in the same window, not a new Excel Window:
Print |Content-Type:application/vnd.ms-excel; filename=“| + DefaultFileName + |”|
(Because I am in the current window, I do not see all the normal Excel headers like File, Edit, View, Insert, etc.)
What can I do to get rid of that 2nd prompt?