View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
vandenberg p[_3_] vandenberg p[_3_] is offline
external usenet poster
 
Posts: 1
Default Open file behavior with add-in

I have written an add-in that when it is loaded, Excel will
not load a file that has been double clicked unless Excel is
open already. If Excel is not open the file will not load
although Excel does not load a default blank spreadsheet as it
does if I load Excel directly. (This is not the well known
uncheck the ignore other application box problem.) If the
add-in is not loaded everything works fine. I have other
add-ins loaded that do not affect the behavior so I am
reasonably sure that it is something in my add-in that
causes the problem.

Most of the code is a module (over 5000 lines). A little
is in this workbook module and a little is in forms
modules. Since there is a lot of code it is difficult to
know where to start looking for the problem. Can anyone
suggest where I might look or even better if you suspect
you know where the problem is can you tell me. Thank you.


Pieter Vandenberg