Excel automation failure

[Jack]

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

 

[RB Smissaert]

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

RBS

 

[Jack]

Please tell me how my code can be revelant in that case if it works most of
the time and when it does not the reinstalling MsOffice clears that problem?
Jack

 

[RB Smissaert]

Without seeing the code is hard to tell if it is relevant or not.

RBS

 

[Paul Clement]

¤ 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)