2-part question re downloading to Excel

1. I am trying to output data in Excel format from a download button on a Webspeed Web screen. When I click on the button, I get the MS download screen fine, but when I ask to "open this file from its current location" I get an App Builder pop-up box as follows:


C:\WINDOWS\Temporary Internet Files\Content.IE5\IJTUDEX7\Exceldown[2].w

This file is not in AppBuilder file format. What do you want the AppBuilder to do?

--------------

I have been unable to get the code samples that I've found in this forum regarding how to rename the file to work, but I don't think this is the problem.

Does anyone know why this is happening?

2. What I really want to do is take the data from a temporary table that's being built and put into the HTML using WSTAG to output to Excel, not use a file. Is there a way to do this?

We're on Progress 9.1, Webspeed 3.1. Right now I'm testing with IE, haven't tried Netscape yet.

Code for question #1 follows:



DEFINE STREAM infile.
DEFINE VARIABLE vdata AS RAW NO-UNDO.

output-content-type("application/x-msdownload").

INPUT STREAM infile FROM ci/security.xls BINARY NO-ECHO.

LENGTH(vdata) = 1024.
REPEAT:
IMPORT STREAM infile UNFORMATTED vdata.
PUT {&WEBSTREAM} CONTROL vdata.

END.
LENGTH(vdata) = 0.
INPUT STREAM infile CLOSE.


Thanks much for your help.
 
Top