I've tried using the following but it is returning the names alphabetically any ideas on how to get the first sheet in the workbook's name without using the excel object?

vb Code:
  1. Dim objConn As OleDb.OleDbConnection
  2.         Dim dt As DataTable = Nothing
  3.  
  4.         Try
  5.             objConn = Connect()
  6.             dt = objConn.GetOleDbSchemaTable(OleDb.OleDbSchemaGuid.Tables, Nothing)
  7.             Close(objConn)
  8.             Return dt.Rows(0).Item("TABLE_NAME").ToString.Replace("''", "'")
  9.         Catch ex As Exception
  10.             Return Nothing
  11.         Finally
  12.             If Not dt Is Nothing Then
  13.                 dt.Dispose()
  14.             End If
  15.             If Not objConn Is Nothing Then
  16.                 Close(objConn)
  17.             End If
  18.         End Try