Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 12
Default Excel 2003 vsto 2005 vb.net - ThisAddIn_Startup problem

Hello,

I have an add-in that works well and executes the me.startup event perfectly
when Excel is started manually.

If Excel is started by double clicking an .xls file, the add-in fails to
start and becomes disabled. The xls file then loads. I can re-enable the
add-in and it executes me.starup fine.

I found that when I strip much code back in me.startup the add-in can start
sucessfully when double clicking an .xls file to open Excel.

There does not appear to be any 'offending code' that causes the problem, it
appears to be more along the line of timing.

Thanks for considering this problem.


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Excel 2003 vsto 2005 vb.net - ThisAddIn_Startup problem


You need to isolate the problem futher. There can be differences in how
a macro is executed based on how th e file is opened. For example, the
active sheet may not be the same. Hre are some suggestions

1) Change you security level to medium t make sure the security level
is not set to high where the macro will not run

2) Change your error handling to Stop on all errors. You may be
skipping over some errors that will give you a clue to your problem

VBA menu - tools - OPtions - General - Error Trapping - Stop on all
Errors

3) Comment out all your On Error statements so the code will stop on
the error and tell you where the error is occuring

4) To help isolate the problem Add STOP statements in the code. You
can press F5 to continue past the stop statement. I usually debug
problems that occur when workbooks are opened by placing STOP at the
beginning of the workbook open macro. Then see if the problem still
occurs. Then add more stops until I isolated the problem.


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=165901

Microsoft Office Help

Reply
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 2003 Add-in with C# and VSTO 2005 doesn't show custom menu Peder Myhre Excel Programming 1 February 4th 08 10:16 PM
VSTO 2005 Excel Addin Lucky Luke Excel Programming 0 July 26th 07 03:16 PM
Document Level Project in VSTO 2005 For Excel 2003 Jagdish D Excel Programming 1 July 17th 07 03:36 PM
Undo Disabled in Excel 2003 using VSTO 2005 Darryn Lavery Excel Programming 0 November 21st 06 03:39 AM
Calling functions developed in VSTO 2005 from Office Excel 2003 Neil Janabi Excel Programming 0 March 16th 06 11:50 AM


All times are GMT +1. The time now is 10:07 AM.

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

About Us

"It's about Microsoft Excel"