LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Custom Addin Reference Crashes Excel

I have a very challenging issue for you. I have created a custom addin that
contains common code that can be used across many workbooks. I add a
reference to the addin in my workbook and the 1st time that it calls the
addin, things run fine. If I then save the workbook, reopen and call the
addin again, Excel crashes. My issue can be duplicated by doing the
following.

1) Close any other workbooks in Excel, so that you don't lose anything.
2) Create an addin with a single function ... say ...
Public Function ReturnString() as String
ReturnString = "Test"
End Function
3) Save this addin locally
4) Create a new workbook
5) In the Visual Basic Editor, add a reference to this addin
6) Create a button on Sheet1 and have it point to code that says ...
Range("A1").value = MyAddin.ReturnString
7) Save the workbook, click the button and everything works fine.
8) Now, delete the text from cell A1, save the workbook and close Excel.
9) Reopen the workbook and click the button.
10) Observe Excel crash

Why is this happening?

Would anyone be willing to take this on? It will take about 5-10 minutes to
duplicate. It is killing my coworkers and me ... we can't figure it out.

Thanks in advance,

Scott
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2000 crashes when using custom views. [email protected] Excel Discussion (Misc queries) 0 September 7th 07 03:20 PM
Addin Reference crashes Excel PrairieHome Excel Programming 3 December 7th 05 10:12 PM
addin crashes on only 1 computer Ric[_6_] Excel Programming 2 November 22nd 04 07:58 PM
Solver Reference in Hidden Personal.XLS Crashes Excel 2003 [email protected] Excel Programming 1 July 12th 04 11:48 AM
Custom Addin, Excel Shutdown Problem RodT Excel Programming 4 April 15th 04 06:14 AM


All times are GMT +1. The time now is 04:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"