View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
RB Smissaert RB Smissaert is offline
external usenet poster
 
Posts: 2,452
Default How to handle automation error?

Have a .xla add-in and with one user only there is an automation error in
the Workbook_Open event of this
add-in.
The problem is that although there is an error handler
in this procedure it doesn't do anything and all that shows
is the message Automation error, error 440.
How would I catch this error?
This is a new installation of Excel XP. Previously on the same computer with
Excel 9 or 10 there was no
problem.

RBS