a problem with excel addin
As I've said I don't know C# but if the "IDTExtensibility Interface" exists
correctly I would have thought it should compile to a recognized com-addin.
I am building the project and debugging it such that it starts an external
program and that external program is set to MSExcel. In
With VB6 you can run as a Com-Addin from the VB_IDE, ie step through the
uncompiled code. It's all a bit flaky and means starting everything in the
right order. I have no idea if you can do that with C#, maybe not. Have you
tried compiling it and then adding the compiled dll via the ComAddins
button.
And, to add to the information, am actually adding a new commandbar and in
this commandbad lies my button. Am able to see my commandbar with the
button
only when I start writing " ='...' "
That makes sense if it is only installed as an automation-addin, I explained
that in my last post. If your addin contains effectively only UDFs normally
it should not be necessary to include any buttons at all.
Regards,
Peter T
"NA_AB" wrote in message
...
Yes peter, it appears like you said, in
excel--tools--Add-Ins--MyAddin.Connect. Am sorry if I had confused you,
I
was a little unsure.
And for the "tools--ComAddins" one which you said, my Addin was not
already
present there, so I tried to add my ".dll" but it just popped up this
error,
"It is not a valid Office Addin"
though for the latter it needs to have been compiled as such (ie an
Office addin/comaddin).
Am I missing this??? How do I compile it that way?
And the template about "IDTExtensibility Interface" etc which you talked
about are all present.
I am building the project and debugging it such that it starts an external
program and that external program is set to MSExcel. In this excel sheet
opened, I wanted my button to be shown automatically, but I'm having to
first
call one of the Connect events to see it.
And, to add to the information, am actually adding a new commandbar and in
this commandbad lies my button. Am able to see my commandbar with the
button
only when I start writing " ='...' "
I tried lookin in the "Customize" also, but am not able to see my
commandbar
until i start " =... " in any of the excel cells.
|