View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
E F Leo E F Leo is offline
external usenet poster
 
Posts: 1
Default Ole Server Error related to Office 2007 installation

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?