email a attached file vb.net

[Member_14500218]

unable to create a win-from for mailing 2 many clients using vb.net

[Chris Quinn]

You have our sympathies.

========================================================= I'm an optoholic - my glass is always half full of vodka. =========================================================

[Dave Kreskowiak]

Again. Without the code you're using and a description of any problem or errors you're having, it's impossible for anyone to help you. Stop typing as little as possible.

Asking questions is a skill CodeProject Forum Guidelines Google: C# How to debug code Seriously, go read these articles.
Dave Kreskowiak

[Member_14500218]

Dear Friends at code project, The code i use is as follows

Private Sub BtnExcel_Click(sender As Object, e As EventArgs) Handles btnExcel.Click
Try

        Dim MyConnection As System.Data.OleDb.OleDbConnection
        Dim dataSet As System.Data.DataSet
        Dim MyCommand As System.Data.OleDb.OleDbDataAdapter
        Dim path As String = "C:\\Users\\Abhimanyu Singh\\Documents\\excel\\SalarySlip.xlsx"

        MyConnection = New System.Data.OleDb.OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + path + ";Extended Properties=Excel 12.0;")
        MyCommand = New System.Data.OleDb.OleDbDataAdapter("select \* from \[salaryslip$\]", MyConnection)

        dataSet = New System.Data.DataSet
        MyCommand.Fill(dataSet)
        DataGridView1.DataSource = dataSet.Tables(0)

        MyConnection.Close()
    Catch ex As Exception
        MsgBox(ex.Message.ToString)
    End Try

End Sub

End Class

It works well for a single Excel file but if i try to open another fileit gives me error "OBJECT VARIABLE OR WITH BLOCK VARIABLE NOT SET" IAM NOT ABLE TO MOVE AHEAD PLEASE SUGEST REMIDIES