We're so close...

So far this is what I've got:


Private Sub cmdExcel_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdExcel.Click
Try
Dim FileName As String = "PendingSteps.xls"
Dim FileAndPath As String = "C:\My Documents\" & FileName
Response.Clear()
Response.ContentType = "application/vnd.ms-excel"
Response.AppendHeader("Content-Disposition", "attachment; filename=" & FileName)
Response.Flush()
Response.WriteFile(FileAndPath)
Catch ex As OleDb.OleDbException
lblError.Text = "There has been an error. Please advise MIS of this error message: " & ex.Message
End Try
End Sub


It is finally making an Excel worksheet, but it's 0 bytes (meaning it's not sending the datagrid, just a blank file) How would I make sure the datagrid is going too?

Thanks again for all the help Ken...


Ooogs