Filename has Url in file-save dialog when saving exported Excel do
 

Hi Sam;

This is the normal behavior since when you tell the web
server to return the type as Excel what it really does is
to server up the html page in Excel and not a real Excel
sheet. You can create a VBA routine that will
automaticall save it and make it a real spreadsheet.

Then you will be able to force the name and file type.

Thanks,

Greg


-----Original Message-----
Hi All,

Using the Excel API, I convert an HTML document to Excel
and stream it to
the browser. The spreadsheet appears correctly inside
the IE browser.
However, when I try to save the spreadsheet via the Save-
As from the file
menu, the Url (to the original Html doc) appears in the
filename instead of
the filename specified in the header's Content-
disposition.

Please help/share if you came across a similar
situation/problem like this
and found a solution for it. Thank you very much in
advance.

Sam
.