Opening of an excel file is also giving a run time error

[prem]

Trying to make use of Excel 97/2000 programming for
reading data from excel to SQL Database

The programs was working fine for a long time 20 + months.
But suddenly failing on running the program in Visual
Basic even a simple creation of excel object & opening a
file is also giving an error

Code
Set oExcelApp =CreateObject("Excel.Application")

Set oExcelWorkbook = oExcelApp.Workbooks.Open(sFilename)
'sfilename includes the file name & path
' the error that is displayed is

run-time error '-2147022979 (8007077d)':

Method 'Open' of object workbooks failed

Try to make the excel visible also gives error

oExcelApp.Visible = True

run-time error '-2146960888 (8007fa08)':

Method 'Visible' of object '_Application' failed


Thanks
Prem

 

[Tom Ogilvy]

If it worked for 20 months, what has changed. That would be the first place
to look for problems. If nothing, then perhaps you just need to clean the
file. Look at Rob Bovey's free code cleaner addin.

http://www.appspro.com

look in free downloads.

 

[Renato Wisocki Junior]

Trying to make use of Excel 97/2000 programming for
reading data from excel to SQL Database

The programs was working fine for a long time 20 + months.
But suddenly failing on running the program in Visual
Basic even a simple creation of excel object & opening a
file is also giving an error

Wonderfull! I found that it's a Microsoft Patch that make's this
happen, it's SP4, so uninstall it and everything should work nice
again, or install Excel service release SR-1 and it should solve it.
God bless Bill Gates.