I've got a table of results that I'm trying to export to Excel (asp script) -- and although I can export them fine using Firefox, I get errors when using IE 6.0. I'm 99.9% sure the ASP and HTML are coded properly on the scripts (since it's working in Firefox), and I don't have any special security settings set on that file.
Here are the errors we get when we try to export this file from the web to Excel:
(If choosing "Open"):
1. Could not open 'http://www.mydomain.com/exportfile.asp'
2. MS Excel cannot access the file 'http://www.mydomain.com/exportfile.asp'. There are several possible reasons:
-file name or path name does not exist
-file you're trying to open is being used by another program. Close the document in the other program, and try again
-name of the workbook you're trying to save is the same name of another document that is read-only. Try saving the workbook with a different name.
[I Can assure you it's NONE of the above in #2]
(If choosing to "Save") we get:
Internet Explorer cannot download exportfile.asp from www.mydomain.com/exportfile.asp. IE was not able to open this Internet site. The requested site is either unavailable or cannot be found. Please try again later.
We get these errors on machines running Windows XP SP1, XP SP2, Excel 2002 SP2, Excel 2003 SP1. My IE version is the latest as of the time of this posting (IE 6.0.2800.1106.xpsp2.040919-1003). And my IE Security settings are in good shape (yes, I can enable downloads).
Note, that it's only when I try to export this file is when we get these errors, and that it is working fine on Firefox... I'm completely stumped, this one's worth a bunch of points.
Any help is thoroughly appreciated!