The code you posted looks reasonable. Presumably you have the bracket % before the code starts and % bracket afterwards.

Once the document has been created and saved on the web server (which may be harder than you think because of permissions for the IUSER_MACHINE account,
you can simply do a
Response.Redirect(lcFilename)

lcfilename should have the complete physical path.

Depending on the user machine, this will cause either a download dialog or word to open in the browser.


>Hi All,
>
>This question is for my husband (I don't have much experience with web page creation, but lots with VFP & COM). He is working on a project creating a Web application. He is using ASP to create the pages. The data is stored in SQL 7. What he wants to do is have a button on an ASP created Web page that the user can click to generate a Word Document report from the SQL 7 data. Before/After creation of the Word document the user is prompted to save it on their hard drive. I think he needs to do some VB scripting.
>
>Something along the lines of:
>

>SQL = SELECT customer, widget from CustWidget where customer = 'SMITH'
>set rs = Conn.Execute(sql)
>set oWord = CreateObject('Word.Application')
>set oDocument = oWord.Documents.Add()
>set oRange = oDocument.Range()
>oRange.InsertAfter('Customer ID:'+ rs('customer')+ CHR(13) )
>oRange.InsertAfter('WigitID:'+ rs('widget')+ CHR(13) )
>.
>.
>.
>** finished creating Word document
>** ...prompt user for file name
>oWord.ActiveDocument.SaveAs(lcFileName)
>

>
>Is this the correct syntax? Does the whole block of code have to be wrapped in %?
>
>TIA,
>
>Jacci