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

Open file behavior with add-in
 

It might not be the addin's fault...

Sometimes one of these works:

Tools|Options|General|Ignore other applications (uncheck it)

--- or ---

Close Excel and
Windows Start Button|Run
excel /unregserver
then
Windows Start Button|Run
excel /regserver

The /unregserver & /regserver stuff resets the windows registry to excel's
factory defaults.



vandenberg p wrote:

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

--

Dave Peterson

Open file behavior with add-in
 

Dave:

Thank you for your response. I had already double checked to make sure "Ignore other etc
was unchecked. Also I had tried the excel /unregserver etc also. And to be sure I just
did it again. It does not change the behavior. The only thing that seems to cure
the problem that I have found is to unload the add-in.

Pieter Vandenberg


Dave Peterson wrote:
: It might not be the addin's fault...

: Sometimes one of these works:

: Tools|Options|General|Ignore other applications (uncheck it)

: --- or ---

: Close Excel and
: Windows Start Button|Run
: excel /unregserver
: then
: Windows Start Button|Run
: excel /regserver

: The /unregserver & /regserver stuff resets the windows registry to excel's
: factory defaults.



: vandenberg p wrote:
:
: 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

: --

: Dave Peterson

Open file behavior with add-in
 

I guess that just leaves a "good luck" in your search.

Maybe you can just comment out subroutine by subroutine and see what breaks the
setting.

(I don't have a better guess.)

Good luck <vbg.

vandenberg p wrote:

Dave:

Thank you for your response. I had already double checked to make sure "Ignore other etc
was unchecked. Also I had tried the excel /unregserver etc also. And to be sure I just
did it again. It does not change the behavior. The only thing that seems to cure
the problem that I have found is to unload the add-in.

Pieter Vandenberg

Dave Peterson wrote:
: It might not be the addin's fault...

: Sometimes one of these works:

: Tools|Options|General|Ignore other applications (uncheck it)

: --- or ---

: Close Excel and
: Windows Start Button|Run
: excel /unregserver
: then
: Windows Start Button|Run
: excel /regserver

: The /unregserver & /regserver stuff resets the windows registry to excel's
: factory defaults.

: vandenberg p wrote:
:
: 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

: --

: Dave Peterson

--

Dave Peterson

Open file behavior with add-in
 

Dave:

Again thanks, I was hoping to avoid that but sometimes you can't.

Pieter


Dave Peterson wrote:
: I guess that just leaves a "good luck" in your search.

: Maybe you can just comment out subroutine by subroutine and see what breaks the
: setting.

: (I don't have a better guess.)

: Good luck <vbg.

: vandenberg p wrote:
:
: Dave:
:
: Thank you for your response. I had already double checked to make sure "Ignore other etc
: was unchecked. Also I had tried the excel /unregserver etc also. And to be sure I just
: did it again. It does not change the behavior. The only thing that seems to cure
: the problem that I have found is to unload the add-in.
:
: Pieter Vandenberg
:
: Dave Peterson wrote:
: : It might not be the addin's fault...
:
: : Sometimes one of these works:
:
: : Tools|Options|General|Ignore other applications (uncheck it)
:
: : --- or ---
:
: : Close Excel and
: : Windows Start Button|Run
: : excel /unregserver
: : then
: : Windows Start Button|Run
: : excel /regserver
:
: : The /unregserver & /regserver stuff resets the windows registry to excel's
: : factory defaults.
:
: : vandenberg p wrote:
: :
: : 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
:
: : --
:
: : Dave Peterson

: --

: Dave Peterson