Excel automation failure

  • Thread starter Thread starter Jack
  • Start date Start date
J

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