What is your code to automate Excel?
Have you set a reference to Excel?

RBS


"Jack" <replyto@it wrote in message
...
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)?
Your comments appreciated,
Jack