Excel automation failure
 

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

Excel automation failure
 

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

Excel automation failure
 

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" wrote in message
...
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

Excel automation failure
 

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

RBS


"Jack" <replyto@it wrote in message
...
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" wrote in message
...
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

Excel automation failure
 

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)