Open File Error

davec · October 4, 2005, 1:20pm

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

Laurence · October 4, 2005, 4:28pm

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.

davec · October 4, 2005, 4:38pm

Here is a copy of the file

Laurence · October 4, 2005, 5:07pm

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.