Open File Error


To open an excel in I use

Excel1.Open("V:\Net Projects\VGSII\Extracts\MGAM_REVDAY 6-28.xls", FileFormatType.Default)

I get "Index was outside the bounds of the array"

Using short names like C:\text.xls work OK


I think it may be caused by the file itself instead of the file name. Could you please post your MGAM_REVDAY 6-28.xls file here? I will check it right now.


Here is a copy of the file


I think this file is not created with MS Excel, right? I use Excel97 to open and save this file and all work fine. Please try this re-saved file.