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'd change it to

Set oX=Createobject("Excel.application")
Set oBook= oX.Workbooks.Add()

HTH,
Barb Reinhardt

"E F Leo" wrote:

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?

Sorry I did not mention the language is MS Visual FoxPro (VFP) so
this suggestion will not work. The thing is that in VFP the syntax in use
is equivalent to your suggested change.

I now have more information from the client.

The installation of MS Office 2007 was customized by their IT department.

At this point I'm theorizing they did not include files needed for
automation when they built that installation for general distribution (huge
organization) and only 30 people use the VFP custom app and a handful of
those need the automation.

How does that stand up as a theory?

"Barb Reinhardt" wrote:

I'd change it to

Set oX=Createobject("Excel.application")
Set oBook= oX.Workbooks.Add()

HTH,
Barb Reinhardt

"E F Leo" wrote:

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?