0

Good day folks,

I've been wondering how can I open an excel file in vb.net. Can somebody help me?

I always get this error below:

The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)

Thanks in advance

4
Contributors
4
Replies
23
Views
3 Years
Discussion Span
Last Post by GeekPlease
Featured Replies
  • Two possible scenarios 1. If the data is in tabular form you can open the Excel files using ADO or OleDb and read the data like a database 1. You can use automation objects to access the data cell by cell I have a sample project for each that I … Read More

0

Thanks guys :)

I already solved my problem. And for some people with the same problem, I'll show you what I've done.

        Try
            Dim xlApp As Object
            xlApp = CreateObject("Excel.Application")
            xlApp.Visible = True
            xlApp.Workbooks.Open(strFileName)
            xlApp.UserControl = True
            xlApp = Nothing
        Catch ex As Exception
            MessageBox.Show("Excel file not found", "Validation - 125", MessageBoxButtons.OK, MessageBoxIcon.Error)
            For Each proc In System.Diagnostics.Process.GetProcessesByName("EXCEL")
                proc.Kill()
            Next
            Exit Sub
        End Try
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.