PC Review Forums Newsgroups Microsoft Excel Microsoft Excel Crashes error opening XLS caused by XLA?

Reply

error opening XLS caused by XLA?

 
Thread Tools Rate Thread
Old 17-10-2005, 02:51 PM   #1
=?Utf-8?B?TWFyayB0ZW4gYmVyZ2U=?=
Guest
 
Posts: n/a
Default error opening XLS caused by XLA?


Hi all,

I've got an addin that causes the following error:
"EXCEL.exe generated errors and will be closed by Windows"
This happens when 1) the XLA or it's source-XLS is loaded AND 2) another XLS
is being opened.

Sample code:
"Option Explicit
Public WithEvents AppEvents As Excel.Application

Private Sub AppEvents_WorkbookActivate(ByVal wb As Excel.Workbook)
Call Activate_App(wb)
End Sub
"

Dubugging shows (like) everything is OK, until the end sub statement.
Statements executed within Activate_App are two if's leading to an empty
else-block, nothing else.

Does anyone have a solution? A clue what to look for instead is also welcome.

Thanks in advance.
  Reply With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off