J
Jason Lepack
Hello all,
I developed a COM add-in using VB.NET in VS2003 for Excel 2003. The
add-in works great except for two livable problems.
1. When I exit Excel while the add-in is installed I receive the
"Microsoft Office Excel has encountered a problem and needs to
close." It is an unhandled exception, but it's not in my code. The
debugger is done when this occurs. I haven't been able to find
anything on the internet about this.
2. I have selected the "Trust Access to Visual Basic Project" and
"Trust all installed add-ins" but it seems that these permissions
don't come into play unless I use an XLA. If I unselect all of the
XLA add-ins then try my COM add-in I get the "Programmatic access to
visual basic project is not trusted", but if I select an XLA (such as
Analysis Toolpack", my COM add-in works fine.
Thanks in advance.
Cheers,
Jason Lepack
I developed a COM add-in using VB.NET in VS2003 for Excel 2003. The
add-in works great except for two livable problems.
1. When I exit Excel while the add-in is installed I receive the
"Microsoft Office Excel has encountered a problem and needs to
close." It is an unhandled exception, but it's not in my code. The
debugger is done when this occurs. I haven't been able to find
anything on the internet about this.
2. I have selected the "Trust Access to Visual Basic Project" and
"Trust all installed add-ins" but it seems that these permissions
don't come into play unless I use an XLA. If I unselect all of the
XLA add-ins then try my COM add-in I get the "Programmatic access to
visual basic project is not trusted", but if I select an XLA (such as
Analysis Toolpack", my COM add-in works fine.
Thanks in advance.
Cheers,
Jason Lepack