>An Excel automation process that has worked dependably with Excel 2000 and
>2003 for over 3 years no longer works for a client on systems that have been
>upgraded to Office 2007 - but continues to work on their systems where
>Office 2003 is installed. The application works on my development system
>and on other systems here where Office 2007 is also installed.
>
>The error is "OLE error code 0x80010105: The server threw an exception."
>
>The code is:
>
>oX=Createobject("Excel.application")
>oBook= oX.Workbooks.Add() (fails on this line every time)
>
>Any thoughts?
I've tried here
loExcel = newobject("Excel.Application")
with loExcel
.ScreenUpdating = .f.
.DisplayAlerts = .f.
.WorkBooks.add()
.visible = .t.
endwith
loExcel = null
RELEASE loExcel
and it worked fine for me - Excel 2007.
Could it be corrupted installation ?
If it's not broken, fix it until it is.
My Blog