how to set builtindocument proprties of excel before saving to clientPC
<p>I am trying to set builtindocument property value to excel. Excel is created using response object and pop up the dialog box on client side to save it . I want to assign vaue to document property before the dialog box appears . I am getting exception
when assigning response to new excel.application object.</p>

<pre><code>  string importFile = da.ImportFile(ddlFile.SelectedValue, ddlFile.SelectedItem.Text);
  Response.Clear();
  Response.AddHeader("content-disposition", "attachment; filename=" + ddlFile.SelectedItem.Text + ".xls");

    Response.AddHeader("content-type", "excel");

    using (StreamWriter writer = new StreamWriter(Response.OutputStream))
    {
    writer.Write(importFile);
    }
  Excel.Application oXL = new Excel.Application(Response);             Microsoft.Office.Core.DocumentProperties properties;
properties = (Microsoft.Office.Core.DocumentProperties)oXL.ThisWorkbook.BuiltinDocumentProperties;
 Microsoft.Office.Core.DocumentProperty prop;
 prop = properties["Revision Number"];
if (prop.Value == null)
 {
 prop.Value = 5; // this will be auto-increment
 }
 Response.End();
</code></pre>

<p>Can someone pl. help how I can use response to set builtinproperties . Thanks in advance !</p>
