Author: weng0000 | Posted on: 6/25/2008 12:52:35 AM | Views : 281

The below code is working at home. When i run this at my office,
it does not show the excel when i click the button. It just does nothing.
can anybody help me please. Thank you very much.

Here is the code:
Private Sub printToExcel(ByVal pCustomer As String)
        Dim connString As String = ConfigurationManager.ConnectionStrings("QBRISC").ConnectionString
        Dim conn As New SqlConnection(connString)
        Dim command As SqlCommand
        Dim rs As SqlDataReader
        Dim strSQL As String = String.Empty
        Dim xlApp As Excel.Application
        Dim xlWb As Excel.Workbook
        Dim xlWs As Excel.Worksheet
&nbs ...

Go to the complete details ...