Open File Error


#1

To open an excel in VB.net 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


#2

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.


#3

Here is a copy of the file


#4

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.