On Thu, 20 Nov 2008 13:26:22 -0500, "Jack" <replyto@it wrote:

¤ Hello,
¤ My app (written in vbasic5) accesses spreadsheet using Excel
¤ automation.
¤ From time to time I have calls from new users wanted to use my app, that my
¤ app cannot find any opened spreadsheet.
¤ In most cases reinstalling MsOffice clears that problem.
¤ My question is why or what causes Excel automation failure?
¤ How widespread that problem is?
¤ What else user can try to restore automation (besides reinstalling
¤ MsOffice)?

Could be versionitis with respect to Excel, especially if you're using early-binding and supporting
different versions of Excel. It would help to know what type of error messages occur, if any.


Paul
~~~~
Microsoft MVP (Visual Basic)