create Excel Worksheet from web page using IE

  • Thread starter Thread starter Ed Young
  • Start date Start date
E

Ed Young

We have a link on a web page so our users can save a copy
of the data to a speadsheet.

When I (some people) click the webpage link I get a dialog
box asking me where I want to save the .xls document.
That's what I want...trouble is some people just get
the .xls document within the same web
page frame.

We are all using Windows XP, IE6, and have the same Office
software...what's going on and how do I either set their
browser or force a .xls document to be created? I don't
want to tell them to right click to save...it should work
the same for us all.

If you want to see the aso code:
<%
Response.ContentType = "application/vnd.ms-excel"

set conntemp=server.createobject("adodb.connection")
cnpath="DBQ=" & server.MapPath
("..\..\..\dbs\Access_Files\expense.mdb")
conntemp.Open "DRIVER={Microsoft Access Driver (*.mdb)}; "
& cnpath
set rs=conntemp.execute("select * FROM AllExpenses2004
WHERE Account LIKE '%"
& Request.Form("Account") & "%'")
%>
 
Ok....
Seems version 6.0.2800.1106 xpsp2.o30422-1633 exports the
information to a .xls document
While version 6.0.2800.1106 puts the information in a web
page.

So it works right in WinXP but not in Win200 or 98
Is there any way to change this?
 
Ed,
Two possibilities, from the individual workstation point-of-view.

1. Folder options> File types> XLS> Advanced> check "Confirm open after
download" and uncheck "Browse in the same window."

2. 162059 - How to Configure Internet Explorer to Open Office Documents in
the Appropriate Office Program Instead of in Internet Explorer:
http://support.microsoft.com/default.aspx?scid=kb;[LN];162059

Hope this helps,
Don
 
If you want to save it can't you right-click and use Save Target As...?

Otherwise you need to break the association of the filetype
or at least check "Confirm Open After Download"

<title>KB162059 - How to Configure Internet Explorer to Open Office Documents in the Appropriate Office Program Instead of in
Internet Explorer</title>

<title>KB318761 - PRB: Open Button in Dialog Disabled When You Browse or Redirect to .rtf or .csv Files</title>

(MSKB Boolean search for
xls AND "folder options" AND kbie600search
)


HTH

Robert Aldwinckle
 
Back
Top