Hi all,
Im trying to build an excel addin using c# and visual studio. In my addin,
Im generating a button which I want to be displayed as soon as I open my
excel. I did the COM registration also. The button is showing up but only
after I start writing a €œformula€� in an excel cell like (=sum, =count) etc. I
shifted my create button code from Onstartup Complete and Onconnection of
Connect.cs but of no use.

thanks in advance

If you have 'Initial load behavior' set to 'load on demand' change it to
'StartUp'

In Excel, is the addin installed under Tools/Com Addins... as well as
Addins/Automation addins (if used for UDF's)

Regards,
Peter T

"NA_AB" wrote in message
...
Hi all,
I'm trying to build an excel addin using c# and visual studio. In my
addin,
I'm generating a button which I want to be displayed as soon as I open my
excel. I did the COM registration also. The button is showing up but only
after I start writing a "formula" in an excel cell like (=sum, =count)
etc. I
shifted my create button code from Onstartup Complete and Onconnection of
Connect.cs but of no use.

thanks in advance

hey thanks for replying Peter, but could you just tell me where to find this
'Initial Load Behavior'???
Are you talking about the one in
MSExcel--Tools--Macro--VisualBasicEdiitor???
But, I'm am using visual studio and building a new Extensibility(Visual
Studio Addin) project. Can I make changes to
'Initial Load Behavior' programmatically, say in my 'connect.cs'? If yes.
could you please tell me how??


Also, the addin is installed in the tools/com addins.

Thanks.

I don't know C# but in VB6 the 'Initial Load Behavior' setting is available
during design, via a dialog in the VB-IDE when the connect class is
selected.

If you look in Excel / Tools / Com Addins "Load behavior" is shown at the
bottom of the dialog.

Regards,
Peter T

"NA_AB" wrote in message
...

hey thanks for replying Peter, but could you just tell me where to find
this
'Initial Load Behavior'???
Are you talking about the one in
MSExcel--Tools--Macro--VisualBasicEdiitor???
But, I'm am using visual studio and building a new Extensibility(Visual
Studio Addin) project. Can I make changes to
'Initial Load Behavior' programmatically, say in my 'connect.cs'? If yes.
could you please tell me how??


Also, the addin is installed in the tools/com addins.

Thanks.

problem again peter, when am choosing from tools, com addins, my ".dll", it
says, abhi.dll is not a valid Office addin!!!

If it were not valid, how is my project building and working fine? all my
UDFs are working fine in excel.

"Peter T" wrote:

I don't know C# but in VB6 the 'Initial Load Behavior' setting is available
during design, via a dialog in the VB-IDE when the connect class is
selected.

If you look in Excel / Tools / Com Addins "Load behavior" is shown at the
bottom of the dialog.

Regards,
Peter T

"NA_AB" wrote in message
...

hey thanks for replying Peter, but could you just tell me where to find
this
'Initial Load Behavior'???
Are you talking about the one in
MSExcel--Tools--Macro--VisualBasicEdiitor???
But, I'm am using visual studio and building a new Extensibility(Visual
Studio Addin) project. Can I make changes to
'Initial Load Behavior' programmatically, say in my 'connect.cs'? If yes.
could you please tell me how??


Also, the addin is installed in the tools/com addins.

Thanks.

I really don't know. But I'm confused, in your previous reply your said
"Also, the addin is installed in the tools/com addins." So is it or isn't it
?

Regards,
Peter T


"NA_AB" wrote in message
...
problem again peter, when am choosing from tools, com addins, my ".dll",
it
says, abhi.dll is not a valid Office addin!!!

If it were not valid, how is my project building and working fine? all my
UDFs are working fine in excel.

"Peter T" wrote:

I don't know C# but in VB6 the 'Initial Load Behavior' setting is
available
during design, via a dialog in the VB-IDE when the connect class is
selected.

If you look in Excel / Tools / Com Addins "Load behavior" is shown at the
bottom of the dialog.

Regards,
Peter T

"NA_AB" wrote in message
...

hey thanks for replying Peter, but could you just tell me where to find
this
'Initial Load Behavior'???
Are you talking about the one in
MSExcel--Tools--Macro--VisualBasicEdiitor???
But, I'm am using visual studio and building a new Extensibility(Visual
Studio Addin) project. Can I make changes to
'Initial Load Behavior' programmatically, say in my 'connect.cs'? If
yes.
could you please tell me how??


Also, the addin is installed in the tools/com addins.

Thanks.

Peter,
Why does this link say
http://support.microsoft.com/kb/291392

"All Automation Add-ins are loaded on demand; there is no setting that can
change the load behavior for an Automation Add-in"

...when we can set the load behavior of Automation addins to load-on-startup.


"Peter T" wrote:

If you have 'Initial load behavior' set to 'load on demand' change it to
'StartUp'

In Excel, is the addin installed under Tools/Com Addins... as well as
Addins/Automation addins (if used for UDF's)

Regards,
Peter T

"NA_AB" wrote in message
...
Hi all,
I'm trying to build an excel addin using c# and visual studio. In my
addin,
I'm generating a button which I want to be displayed as soon as I open my
excel. I did the COM registration also. The button is showing up but only
after I start writing a "formula" in an excel cell like (=sum, =count)
etc. I
shifted my create button code from Onstartup Complete and Onconnection of
Connect.cs but of no use.

thanks in advance

Yes it's confusing. An aX dll addin can be a ComAddin or an Automation
addin, or both. I have a dll that loads on startup (ComAddin) to prepare
things (FWIW adds info for display in the function wizard) and as an
Automation addin for its UDF's.

As a ComAddin and with the IDTExtensibility2 there are various Load behavior
options which can be pre-defined (or changed later in the registry). At
least there are in VB6, I don't know about C#.

It wasn't clear to me what the OP had, indeed I asked (see my Q quoted
below)

Regards,
Peter T

"booleanlogic" wrote in message
...
Peter,
Why does this link say
http://support.microsoft.com/kb/291392

"All Automation Add-ins are loaded on demand; there is no setting that can
change the load behavior for an Automation Add-in"

..when we can set the load behavior of Automation addins to
load-on-startup.


"Peter T" wrote:

If you have 'Initial load behavior' set to 'load on demand' change it to
'StartUp'

In Excel, is the addin installed under Tools/Com Addins... as well as
Addins/Automation addins (if used for UDF's)

Regards,
Peter T

"NA_AB" wrote in message
...
Hi all,
I'm trying to build an excel addin using c# and visual studio. In my
addin,
I'm generating a button which I want to be displayed as soon as I open
my
excel. I did the COM registration also. The button is showing up but
only
after I start writing a "formula" in an excel cell like (=sum, =count)
etc. I
shifted my create button code from Onstartup Complete and Onconnection
of
Connect.cs but of no use.

thanks in advance

Peter,
Why does this link say

"All Automation Add-ins are loaded on demand; there is no setting that can
change the load behavior for an Automation Add-in"

...when we can set the load behavior of Automation addins to load-on-startup.




"Peter T" wrote:

If you have 'Initial load behavior' set to 'load on demand' change it to
'StartUp'

In Excel, is the addin installed under Tools/Com Addins... as well as
Addins/Automation addins (if used for UDF's)

Regards,
Peter T

"NA_AB" wrote in message
...
Hi all,
I'm trying to build an excel addin using c# and visual studio. In my
addin,
I'm generating a button which I want to be displayed as soon as I open my
excel. I did the COM registration also. The button is showing up but only
after I start writing a "formula" in an excel cell like (=sum, =count)
etc. I
shifted my create button code from Onstartup Complete and Onconnection of
Connect.cs but of no use.

thanks in advance