>>Hi,
>>
>>I have a code in my app that opens an Excel file (for printing) and it works for many customers. But this one customer reports a problem. The code that opens the file is as following:
>>
>>
>>oExcel = CREATEOBJECT("Excel.Application")
>>IF type( "oExcel" ) = "O" and !isnull( oExcel )
>> TRY
>> oWorkBook = oExcel.Workbooks.open(ALLTRIM(tcDocumentName))
>> oWorkBook.Printout()
>>CATCH TO oErrorObj
>>*-- show error
>>FINALLY
>> oExcel.Quit()
>>ENDTRY
>>
>>
>>The error number caught by the try/catch is Ole IDispatch 1429. The version of the installed Office is 2007 SP2.
>>
>>What could be causing this error? TIA.
>
>
>The error from Automation is ALWAYS (OK, almost ALWAYS) 1429 :-)
>What is the other part of the error?
Sorry I didn't know that 1429 is not significant. The rest of the error says:
OLE iDispatch exception code 0 from Microsoft Office Excel c:\folder name\document name.xls could not be found.
Wow, now that I type this message I see that there is something wrong with the file not being there. Thank you.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham