View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
prem prem is offline
external usenet poster
 
Posts: 1
Default Opening of an excel file is also giving a run time error

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