Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
40
Excel File Error On Load
posted

I have 2 seamingly identical excel files.  Here is a portion of my code:

Dim iWorkbook As Infragistics.Excel.Workbook

....

Try
          iWorkbook = Infragistics.Excel.Workbook.Load(Me.lblDatafilePath.Text)
Catch ex As Exception
          DisplayMsgBox("There was an error opening Excel Workbook.  The error is: " & ex.Message)
          Exit Sub
End Try

.....

File, Test1.xls works fine.  File Test2.xls fails on the Workbook.Load line with an error of:  "The number of copies must be between 1 and 65535.
Parameter name: value Actual value was 0."

I have compared the files using multiple XLS file compare utilites and they compare as identical.  I'm at a loss!

 Thanks 

 

TestFiles.zip